unmatch two table

[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

 

[Marshall Barton]

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

See how far you can get by creating a query using the Find
Unmatched Query Wizard.

 

[KARL DEWEY]

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;

 

[sq75222]

The tbIn.Date is not same as tbOut.Date, how both tb can join together?