Find deleted records between 2 tables

[margoul1]

Hello,

I have 2 tables, one for April, one for May.

Some line have been deleted in May Table. I want to create a query to find
those lines.

April
1
2
3
4

May
2
3
4

I want the query to return 1.

Thank you very much for your help in advance.

 

[Tom van Stiphout]

On Tue, 10 Jun 2008 20:10:01 -0700, margoul1

That is a HORRIBLE database design that will continue to cause much
grief in the future. What's wrong with having a single table with a
YearMonth field in it?
To get to your point - if you insist - is to query like this:
select * from April
where April.SomeField not in (select May.SomeField from May)

-Tom.

 

[margoul1]

Dear Tom,

Thank you very much for your swift reply.
I finally changed the design of the database.