data not displaying when using outer join

  • Thread starter Thread starter Maria
  • Start date Start date
M

Maria

Hi
I'm having a problem when I have an outer join. Not all
the columns (values) are displayed. I know the sql is
right because if I take the same sql and use it in Query
Analyzer data is displayed.

Does anyone have an answer to this?

Thanks,
 
Hi,


Do you get the same result using the Enterprise Manager? Access and the Enterprise Manager uses the
same dll to communicate with the db, while QA uses something else. Can you post the SQL statement
and specify which columns are not "visible" in the result? Be careful with columns having the same
name, but different origin/table: try using an alias:

SELECT a.toto As f1, b.toto As f2 FROM ...

rather than

SELECT a.toto, b.toto FROM ...


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top