not equal query... 1

[mjonson]

Hi,

have query-
SELECT cuskerr.postc AS kerr, cuskerr.first, cuskerr.last, cusvaux.postc AS vaux, cusvaux.first, cusvaux.last, cuskerr.ID, cusvaux.ID
FROM cuskerr, cusvaux
WHERE (((cuskerr.postc)=[cusvaux].[postc]) AND ((cuskerr.last)=[cusvaux].[last]));

This displays results that are equal to each other
but cannot create query where the output displays
all records in table cusvaux that are not in table cuskerr

ne ideas welcome

 

[Crowley16]

select * from tbl where value NOT IN (select * from tbl)

Procrastinate Now!

 

[PHV]

all records in table cusvaux that are not in table cuskerr
SELECT cusvaux.*
FROM cusvaux LEFT JOIN cuskerr
ON (cusvaux.postc=cuskerr.postc) AND (cusvaux.last=cuskerr.last)
WHERE cuskerr.last Is Null
;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mjonson]

PHV - thanks for that heres a *