SQL help

[rustyg]

I am battling through a query, writing it in SQL. My SQL knowledge is very limited but I am keen to learn.

the query looks like this

SELECT UNAME, AGR_NAME
FROM QASBeforeRefresh
WHERE (QASBeforeRefresh.UNAME and QASBeforeRefresh.AGR_NAME) <> (select UNAME and AGR_NAME from QASAfterRefresh);


there are 2 tables (QASBeforeRefresh and QASAfterRefresh). each table has many UNAMEs and many AGR_NAMEs.

One UNAME can have many AGR_NAMEs and each AGR_NAME can be assigned to many users.

I am trying to return a query giving the UNAME and AGR_NAME from QASBeforeRefresh when that combination does not exist in QASAfterRefresh

I have not set any primary keys and UNAME and AGR_NAME are the only columns in the tables.

Help!

 

[raskew]

Hi -

Checkout this thread http://www.access-programmers.co.uk/forums/showthread.php?t=93166

HTH - Bob

 

[rustyg]

Ripper!

Works like a charm. Thanks very much Raskew


Russ