TOP

sql join not right table

Select *
From ORD
Where ORD_ID Not In
(Select ORD_ID From EXPORTED)

http://miniburb.wordpress.com/2007/05/31/sql-outer-join-vs-where-not-in-vs-not-exists/

Read More
TOP

http://sql-plsql.blogspot.com/

Great site for Pl/Sql example/ref

http://sql-plsql.blogspot.com/2011/05/examples-of-joins.html

great example of

“LEFT OUTER JOIN”
and
“RIGHT OUTER JOIN”

Read More

Switch to our mobile site