Intersect And Minus SQL ... does MS Access support

I

ILuvAccess

Hello All-

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

John Vinson

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]
 
Top