Joining two tables

[abhishekpant]

All

I have two table A and B.
I need to find out the records in table A which are not present in table B

The both the table have secutity ID.

So basically i need to find out that the list of securityId which are present in table A and not in table B.

Can someone help??

Thanks
Abhi

 

[SQLSister]

read about outer joins

http://www.somecoders.com/2006/02/explanation-of-the-different-sql-joins/

"NOTHING is more important in a database than integrity." ESquared

 

[gmmastros]

Select TableA.SecurityId
From   TableA
       Left Join TableB
         On TableA.SecurityId = TableB.SecurityId
Where  TableB.SecurityId Is NULL

When you left join a table, you get all the records from the 'table to the left of the join' and matching records from the table on the right. If there is no match, then the TableB values will be null.

Make sense?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[abhishekpant]

Thanks Goerge

But I need to find out the Ids which are present in table A but not In table B

Does this query do the same thing??

Thanks
Abhi

 

[gmmastros]

Try it.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[abhishekpant]

Goerge

I am new to this..

yeah it works.\


Thanks
ABhi

 

[SQLSister]

You still need to read my link so you understand why it works. This is basic stuf that you need to know backwards and forwards and be able to do without even thinking about it.

"NOTHING is more important in a database than integrity." ESquared

 

[gmmastros]

I agree with SQLSister. The Left Join is one of my favorite SQL Server statements. I encourage you to learn it well.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom