How can i get records from table A which is not in B in sql server. eg A-B

[Shafi hashmi]

Hi dear i have two table in sql like,
A={123}
B={3}
i want to perform
A-B={12}

i have writeen this qry
SELECT a.code FROM A LEFT INNER JOIN B ON b.code AND a.name='shafi'

[gpl]

you are very close, the left join is the answer, but you want to select all the mismatches, that is where there is no b.code -
SELECT a.code FROM A LEFT OUTER JOIN B ON a.code = b.code
where b.code is null

[ck9663]

If you're just looking for records in A that are not in B, you can also use NOT EXISTS...

Good Luck!!!

~~ CK