How to handle Intersection in access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there, I know that access-sql supports "union" but what about
"intersection"?
Let' s say we have 2 sql queries and we 'd like to create the intersection
of them.
How can I do it?
 
That sounds like an Inner Join to me. You would need to join on as many
fields as would define the intersection.

Something like
SELECT *
FROM TableA INNER JOIN TableB
ON TableA.FieldA = TableB.Field01 AND
TableA.FieldC = TableB.Fieldxys AND
TableA.Field9 = TableB.Field3
 
Thank you John.
I' m asking this because in university we compose queries using Oracle. In
Oracle there is an intersect sql statement. Access hasn't any?
Your solutions works fine for me, but I wondered about the existence of an
"intersect" statement.

Thanks again,
John
 
As far as I know there is no Intersect statement in Access SQL or in MS SQL
Server T-SQL.
 
I' m asking this because in university we compose queries using Oracle. In
Oracle there is an intersect sql statement. Access hasn't any?
Click to expand...

Correct. There isn't any.

John W. Vinson[MVP]
 
Back
Top