![]() |
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 |
|
Powered by
DBNest.com (Nest of DB Professionals)
