Rookie Question

[ppantelis]

Table ALPHA: Column_1 Table OMEGA: Column_1
A A
B B
C C
D
I simply want to have as a result the differences between the 2 tables in Column_1, that is D.

What i do (in SQL View)...
SELECT [ALPHA].Column_1
FROM ALPHA INNER JOIN OMEGA ON [ALPHA].Column_1=[OMEGA].Column_1;
WHERE [...WHAT???...]

I 've tried right join, a "not equal" expression, wrongly I guess.

Any help, please?

 

[bborissov]

SELECT [ALPHA].Column_1
FROM [ALPHA]
LEFT JOIN OMEGA ON [ALPHA].Column_1=[OMEGA].Column_1;
WHERE [OMEGA].Column_1 IS NULL

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[ppantelis]

OK!!!
What can I say...
Thank you very much!