How can I do this?

S

SF

Hi,

I want to generate a list of communes that did not have any meeting (in
every month of the year) from 2 table:

tblOperationCommune (CommuneID, CommuneName, Partner...) 356 records
tblMeeting (MeetingID, MeetingDate, CommuneID, MeetingType...)

Can I generate a query to get the following:

Partner CommuneID Month that meeting not help
AAAA 129987 Jan 08
AAAA 123456 Jun 08
BBBB 233444 Aug 08

Hope someone give me some advice

Cheers

SF
 
Top