Search:     Advanced search
Browse by category:
Glossary | Contact Us

Database Knowledge Base / MS Access / How we can perform MINUS (Oracle) Or EXCEPT (Maxdb) in MS Access?

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

Add comment
Views: 381
Votes: 2
Comments: 0

 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

Others in this Category
document When compacting an Microsoft Access database how do you control the ownership of the database?
document How can I make my combo and list boxes faster?
document Where can I obtain a list of Access Basic Errors and their associated messages
document How do I access the recordset of a SUBform. I know how to clone the set of a form, but this doesn't work for subforms.
document How do I emulate the "Record X of Y" that Access displays in the navigation buttons
document How do I run an internal DOS command from within Access Basic, if I try x=Shell("copy file1 file2",1) I get a message "File not found".
document What is Data Mapping
document What is an Ad Hoc Query?



RSS