Left join without condition

Question

Left join without condition

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

dcorbitt Ten Centuries Points: 1006 More actions · Answer 1

Is there a unique index on the tables? If so, what fields comprise it? (Or, is there a way to tell if a record is in both files without comparing every column?)

GSquared SSC Guru Points: 260824 More actions · Answer 2

Am I mistaken, or did I answer this same post in another forum?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

David Leaver Mr or Mrs. 500 Points: 599 More actions · Answer 3

For simplicity, try the EXCEPT operator

SELECT * FROM Table_A

EXCEPT

SELECT * FROM Table_B

shenyjoy SSC-Addicted Points: 421 More actions · Answer 4

Thanks David,

That worked perfectly. It was so simple and I tried it but I did not have tables with same columns and there were additional columns in one select stmt.

Thank you for your help. This works 🙂