unmatch two table

  • Thread starter Thread starter sq75222
  • Start date Start date
S

sq75222

I need a help for my below problem:
I have two table tblIN and tblOUT

tblIn
Date Model OrderNO SN
01/04/09 ABC 001 P123
02/04/09 DEF 001 P234
03/04/09 ABC 001 P123

tblOUT
02/04/09 ABC 001 P123

How to show my BAL as below
02/04/09 DEF 001 P234
03/04/09 ABC 001 P123
 
sq75222 said:
I need a help for my below problem:
I have two table tblIN and tblOUT

tblIn
Date Model OrderNO SN
01/04/09 ABC 001 P123
02/04/09 DEF 001 P234
03/04/09 ABC 001 P123

tblOUT
02/04/09 ABC 001 P123

How to show my BAL as below
02/04/09 DEF 001 P234
03/04/09 ABC 001 P123
Click to expand...


See how far you can get by creating a query using the Find
Unmatched Query Wizard.
 
How to show my BAL as below
You are using term BAL but to me that is not balance which would be
mathematical difference.
Assuming that tblIn will always have a record whereas tblOut will not then
use this --
SELECT tblIn.Date, tblIn.Model, tblIn.OrderNO, tblIn.SN
FROM tblIn LEFT JOIN tblOut ON tblIn.Date = tblOut.Date AND tblIn.Model =
tblOut.Model AND tblIn.OrderNO = tblOut.OrderNO AND tblIn.SN = tblOut.SN
WHERE tblOut.Date Is Null OR tblOut.Model Is Null Or tblOut.OrderNO Is Null
Or tblOut.SN Is Null;
 
Back
Top