Query help

[ace21]

I have two tables

the first one contains a list of all project numbers created
tblProjects
projectid - autoinc
projectnumber

the second table contains progress if different parts of the projectnumber

tblProgress
progressid - autoinc
status - 1-done, 0-not complete
projectnumber

What I am looking to do is select from tblProjects all the projectnumber that are either not in tblProgress or do not have the status of done in tblProgress.

FYI it is basically a system that will allow different pieces of a project(different depts) to be combined under one projectnumber.

Ace21

[Anon]

I've never used LEFT OUTER JOINs, but I think this should work.

Query #1 should give you the projects that do not exist in tblProgress. Query #2 should give you the projects that are not complete. Perhaps someone can suggest how to do this in one query.

#1
SELECT proj., prog. FROM tblProjects AS proj LEFT OUTER JOIN tblProgress AS prog USING (projectnumber)

#2
SELECT proj., prog. FROM tblProjects AS proj, tblProgress AS prog WHERE proj.projectnumber=prog.projectnumber AND prog.progress=0