Database Knowledge Base / MS Access /
Add comment
Name:
Email:
* Comment:
(Use BBcode - No HTML)
code
* Confirmation code:   Write the characters in the image above exactly as you see it


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