Access Query

  • Thread starter Thread starter Radim
  • Start date Start date
R

Radim

Hi,
do you know How I disable automatic repair for query in MS Access.
I write this query: LEFT JOIN ON (xxx=yyy AND zzz=qqq) and save it
when I open it again, access repair to this LEFT JOIN ON xxx=yyy AND zzz=qqq

And when I save it again than Access write error message: Query is not
supported!!! and I must manualy add Bars.

Thanks very much.
Radim
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bars? Do you mean parentheses - ()?

You don't need them if the logic doesn't require them. IOW, from what
you show of your JOIN statement the logic of the JOIN columns'
evaluations doesn't require parentheses around the comparison
evaluations.

This:

(xxx=yyy AND zzz=qqq)

evaluates the same as this:

xxx=yyy AND zzz=qqq

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQgGKoIechKqOuFEgEQJE+ACcCuKzwl8GbYpvfPaZqpTg+MTd1jEAoK2K
+Daxmr8l7hYkQG1jaFpNElkN
=imnX
-----END PGP SIGNATURE-----
 
Back
Top