Query help

[Golfinray]

I am trying to write an iif statement for a query but keep getting it wrong.
I am pulling from 3 tables, 06-07 projects, 07-09 projects, and project type.
I want the query to look like this:
06-07 project # project type 07-09 project # project type
00001 new addition 00002 new
HVAC
00003 new roof
00004 new plumbing 00005 new
electrical
00006 new flooring
00007 new cabinets 00008 new
sidewalks

It looks like this:
00001 new addition 00002
new HVAC
00003 new roof 00002
new hvac
00004 new plumbing 00005 new
electrical
00006 new flooring 00005
new electrical

In other words, I want to return nulls (nothing) where there is no
information.
Thanks so much!!!!

 

[Ken Snell \(MVP\)]

Post the SQL statement of the query as it is right now, so that we can
better understand your setup.