creating an outer join for more than two tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to join 6 tables together; but do not want all of the
information. However, the common fields between them do not produce the
information I need. is there an SQL code that I am missing?
 
More information is needed. The problem could be the SQL or that the
relationships between the tables won't support the query you are trying to
run.

Post the table structures and query.
 
I am trying to join 6 tables together; but do not want all of the
information. However, the common fields between them do not produce the
information I need. is there an SQL code that I am missing?
Click to expand...

Probably.

However, you have not given us any information which would help us
determine what that might be. In particular, you might want to post
the SQL view of the query which is giving the incorrect results, and
indicate what results you expect that you're not getting.

John W. Vinson[MVP]
 
Back
Top