I can't create the joins I want.

Microsoft Query

Show All

I can't create the joins I want.

For an outer join, make sure the query has no more than two tables   If your query has more than two tables, you cannot create an outer join in the query. Outer joins are options 2 and 3 in the Joins dialog box.

A query can have only one outer join   You can create as many inner joins (option 1 in the Joins dialog box) as you want, but you can create only one outer join in each query. If you know how to program in the SQL language, you can try changing the SQL statement in the SQL dialog box (View menu, SQL command) to create more than one outer join.

Information about joins   For information about using outer joins to combine records, click .