Query from two tables that looks for a missing value

[silversubey]

Hello,
I have two tables: CltDue, Checklist

SELECT CltDue.CDClient name, CltDue.CDID
FROM CltDue
WHERE CLtdue.CDstatus = 'More Client info reqst'

shows the following:


project#1 9579
project#2 9956
project#3 9946

SELECT checklist.CDID, Checklist.page
FROM Checklist
shows the following

9579 CLS
9579 INFO
9956 IRO2
9956 SCC

I am trying to query which projects from CltDue are missing an 'INFO' page from the Checklist table.
If I try an = 'INFO' i only get results that have an INFO page. If I try <> 'INFO' I get everything else.

Thank You

[deepuv04]

Hello,
I have two tables: CltDue, Checklist

SELECT CltDue.CDClient name, CltDue.CDID
FROM CltDue
WHERE CLtdue.CDstatus = 'More Client info reqst'

shows the following:


project#1 9579
project#2 9956
project#3 9946

SELECT checklist.CDID, Checklist.page
FROM Checklist
shows the following

9579 CLS
9579 INFO
9956 IRO2
9956 SCC

I am trying to query which projects from CltDue are missing an 'INFO' page from the Checklist table.
If I try an = 'INFO' i only get results that have an INFO page. If I try <> 'INFO' I get everything else.

Thank You

hi,

try the following query ,probably will help you

SELECT distinct CltDue.CDClient name, CltDue.CDID
FROM CltDue
WHERE CltDue.cdid not in (SELECT DISTINCT CDID FROM CHECKLIST WHERE PAGE = 'INFO')


thanks

[silversubey]

Works perfect!
Thank you for the help.