Intersect And Minus SQL ... does MS Access support

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All-

Quick quetion- does MS Acces support the INTERSECT AND MINUS KEYWORDS
concerning SQL?
 
Hello All-

Quick quetion- does MS Acces support the INTERSECT AND MINUS KEYWORDS
concerning SQL?
Click to expand...

Access2003 in SQl/Server ANSI 92 SQL compatibility mode does... but
AFAIK other versions do not. If you use this mode (from Tools...
Options) it applies to the entire database, and you must go all the
way (i.e. use % rather than * wildcards, and I believe lose the
TRANSFORM and Pivot Table features).

John W. Vinson[MVP]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO Minus/Intersect? 3
how do i calculate percentage of change between two or more field. 3
"Minus" keyword 3
Write to intersect of a row and column 7
Equivalent of Minus in Excel. Also Union, Intersect. 6
Emulate XOR in Access 5
Collection Intersection Helper 7
Good morning 5

Back
Top