inner join & outer join in one query

There is nothing wrong with having 10 inner joins and 1 outer join.

The syntax could look something like this in ANSII form:

FROM

  1Table INNER JOIN

  2Table ON (1Table.key = 2Table.KEY) INNER JOIN

  3Table ON (1Table.key = 3Table.KEY) INNER JOIN

  4Table ON (1TAble.key = 4Table.key) INNER JOIN

  5Table ON (1Table.key = 5table.key) INNER JOIN

  6Table ON (1Table.key = 6table.key) INNER JOIN

  7Table ON (1Table.key = 7Table.key) INNER JOIN

  8Table ON (1Table.key = 8Table.key) INNER JOIN

  9Table ON (1Table.key = 9Table.key) INNER JOIN

  10Table ON (1Table.key = 10Tablekey) LEFT OUTER JOIN

  11Table ON (1Table.key = 11Table.key)

You can use more paretheses to group the results if you like.

When building a relationship this complex the best process is to do it one table at a time.

Build the query to correctly return the desired results from the first table.  Then add the second and confirm it is still returning the desired results.  Continue to add the tables one at a time, testing all along the way.