Exclude data through a SQL Statment in a Query 1

[work4livinsean]

Hey everyone,
I am having a problem with a simple SQL Statement. I found something that worked on another thread but when I tried it it did not work. What I am trying to do here is exclude some data from a query by matching up the ApexID's. Here is the SQL Statement:

SELECT queSubmit.Name, queSubmit.ApexID, queSubmit.Number, queSubmit.Okay
FROM tblExclude RIGHT JOIN queSubmit ON tblExclude.Apex_ID = queSubmit.ApexID
WHERE(((queSubmit.[ApexID])<>[tblExclude]![Apex_ID]));

The 'WHERE' statement is what I am having trouble on. Instead of not including the data it simple does not bring up any data. Can anyone help or give me any suggestions? I appreciate your help. Thanks.

Link to the thread where I found a solution that works but not when I try it...

http://www.tek-tips.com/viewthread.cfm?qid=1215245&page=1

Thanks in advance!

 

[Golom]

Maybe you'll see the problem if you reformat it

SELECT queSubmit.Name, queSubmit.ApexID, queSubmit.Number, queSubmit.Okay
FROM tblExclude RIGHT JOIN queSubmit 
        ON tblExclude.Apex_ID [COLOR=red] =[/color] queSubmit.ApexID
WHERE      tblExclude.Apex_ID [COLOR=red]<>[/color] queSubmit.ApexID

The "ON" and "WHERE" clauses are in direct contradiction. The WHERE eliminates exactly those records that were selected by the ON clause.


[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[work4livinsean]

Your right! I read something in the other thread that I posted the link to that said the tables/queries should be connected somehow. Well I did that and that was causing the problem. Thanks you.

 

[PHV]

You wanted this ?
SELECT queSubmit.Name, queSubmit.ApexID, queSubmit.Number, queSubmit.Okay
FROM tblExclude RIGHT JOIN queSubmit ON tblExclude.Apex_ID = queSubmit.ApexID
WHERE tblExclude.Apex_ID Is Null

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