I know it should be a simple task for most of you, but I'm failing to receive the results I need.
This is the relationship between 4 tables:
and this is the query :
I need this query show a list of parts that have no processFK=3 in tblOrderProgress where OrderID=1
The result should contain only these parts:
AL11575BC202 - AL11575BC208
Note:
Actual tables have more than half a million records. So performance counts.
A sample database is attached if you need to test.
I appreciate any kind of help.
This is the relationship between 4 tables:
and this is the query :
I need this query show a list of parts that have no processFK=3 in tblOrderProgress where OrderID=1
The result should contain only these parts:
AL11575BC202 - AL11575BC208
Note:
Actual tables have more than half a million records. So performance counts.
A sample database is attached if you need to test.
I appreciate any kind of help.
Attachments
Last edited: