R
R
Respect and good to all2018-09-12 18:44:27
SQL
Respect and good to all, 2018-09-12 18:44:27

How to create a query in Access so that the numbers of cars from the first table of matches with which there are no matches in the second would be displayed?

Roughly speaking, all license plates from table 1 were displayed that are not in table 2.
How can I do this using the Access visual query designer?
Or even how to implement it?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Y
Yuri, 2018-09-12
@modestguy

roughly speaking:
select license plates from table_1 where license plates NOT IN (select license plates FROM table_2)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question