|
Search:
Advanced search
|
Browse by category:
|
Glossary | Contact Us |
![]() |
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)
