Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 27, 2012 11:13 AM by dhol.gaurav
Dec 27, 2012 11:08 AM|LINK
how to get the values from table A when it does not exists in table B and when Values exists in Table B it should not return, by having some matching fields in both tables.
Dec 27, 2012 11:12 AM|LINK
select * from TableA where columnX_TableA not in (select columnX_TableB from TableB)
hope this helps...
Review this short article http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
Dec 27, 2012 11:13 AM|LINK
You can do using joins example given as below
Select A.* From TableA A Inner Join TableB B Where A.ID != B.ID
Select A.* From TableA A Left outer Join TableB B Where A.ID != B.ID
let me know if any query