Database Knowledge Base

Email to friend
* Your name:
* Your email:
* Friend's email:
Comment:


How we can perform MINUS (Oracle) Or EXCEPT (Maxdb) in MS Access?

 Following query shows all records those are available in table 1 but not available in table 2

SELECT * FROM [TABLE1] LEFT JOIN [TABLE2] ON [TABLE1][PK_ID] = [TABLE2].[FK_TABLE1]  WHERE [TABLE2].[FK_TABLE1] IS NULL




RSS