Queries: Tables w/ 1to1 Relationships

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

Guest

I am trying to create a query with three tables. Table 1's primary key is
the primary key for Table 2 & 3. There may not be a record in Table 2 and/or
3 for every record in Table 1. I would like to display all records from
Table 1 including records from Table 2 and 3 if any. For example, the query
would included Table1:Field1, Table2:Field2, Table3:field3. My query is
blank unless there are corresponding records to Table 1 in both Table 2 and
3. Any ideas?
 
Thank you for replying.

I have tried creating outer joins, but I get a message stating the query can
not be processed because the SQL statement contains ambiguous outer joins.

Also, then I noticed that anywhere from 1-3 additional Table 1's are
automatically being added to my relationships. I have deleted these several
times. Why is the application adding these additional tables (ex/ Table1_1)?

Otherwise, if I simply add the tables to the query, the relationships
automatically appear, but I get zero results.
 
I figured out a way to complete this . . . I created a query including two
tables with an outer join. Then I created another query including the query
and the third table with an outer join. Seems to be working beautifully!
 
Back
Top