i used MS Access database.
when i try to use intersect query in sql. it reply with syntax error.

i know instead of this, use inner join query with where clause and or operator.

but i want to know why intersect query not use in MS Access.

Each kind of database has a little different SQL syntax.

Thanks very much for your kind attention
J. Paul Schmidt