Simple Query Help

[battenberg]

Hi,

I think i am being a bit thick, all I want to do is create a report of projects without products....

I have a table of Projects (customer name, details etc...)
I have a table of Products (product name, config, details etc....)

Every project will eventually have one or more products allocated to it...

How can i query the database for:

'select all projects created without any assigned products... yet'

I'm having a post xmas block!!!

Thanks

 

[MStef]

Let Wizard to create a "Find Unmatched Query Wizard" query.