The intersection of tables A and B contain the rows that exist in both
tables.

Search books on line for "Using EXISTS and NOT EXISTS to Find Intersection
and Difference"

-----Original Message-----
From: Bruno Mário Amaral Almeida [mailto:mutocas@c...]
Sent: Sunday, June 24, 2001 6:19 PM
To: sql language
Subject: [sql_language] Intersection between tables problem.



Hi everybody.
I have this problem and maybe one of you can solve it.
Imagine one table A and another table B.
If you try to do the intersection between the records of the two tables
you wouldn't get a null record. So what i want is these intersection 
records - those
from table A, and in other hand the records from B that don't exist in 
table A.
I hope to be explicit ... if anyone can help i would apreciate very 
much.
One more thing, i=B4m using MSAccess that doesn't let me solve this 
problem with a middle stage by creating a view.
Once more many thanks. 
Bruno Almeida