Does Access support MINUS in query?

Y

Ye

I want to select names from tableA not from tableB. But I
couldn't use MINUS in query in Access. What can I do?


Thanks,
 
I

Ilan

why not have the query just pull info from "table A" minus
is an SQL reserved word i believe, atleast the "-" is.
--Just make table a the source for the query
Ilan
 
D

Douglas J. Steele

SELECT Field1, Field2
FROM TableA
LEFT JOIN TableB
ON TableA.Id = TableB.Id
WHERE TableB.Id IS NULL
 
J

John Spencer (MVP)

Try using the unmatch query wizard to build the query.

Perhaps something like the following will give you a start.

SELECT A.Names
FROM TableA as A Left Join TableB as B
 
Top