data not displaying when using outer join

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,
 
M

Michel Walsh

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
 

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

Top