Ambiguous joins, but query opens?

  • Thread starter Thread starter Shelley
  • Start date Start date
S

Shelley

I have a user who is working with a complex query with a right outer
join on four fields. If you open the query in datasheet view, it's
fine. If you open it in design view, it's fine. But, if you try to
switch to SQL view, you get the error about ambiguous outer joins. He
would like to know why you can run the query and see it in design
view, but then get an error when you go to SQL view?

Thanks!
Shelley
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I've no idea why that is happening. If the person wants to see the SQL
he can use the .SQL property of the querydef. E.g. (debug window):

? CurrentDB.QueryDefs("queryName").SQL

Also, he might try compacting the db file that contains the query. This
may get rid of any corruptions.

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

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

iQA/AwUBQJaHmYechKqOuFEgEQIXrACffxYxRIOIBFINis4pb6hdPFoLTMAAn2Ok
ibjFSx3Kd7MDYMurn9f6Qj+/
=xb0S
-----END PGP SIGNATURE-----
 
Back
Top