Sure you can have LEFT OUTER JOIN with more than 2 tables. What's exact error message? Can you post your query?
>Is there a workaround for the following SQL query join problem?
>
>I have 4 linked tables in an MS SQL Server 2000 Query.
>
>The 4 tables are INNER JOINED
>
>I need to make the link between two of the tables a LEFT OUTER JOIN
>
>Problem:
>Error message from SQL software states that you cannot have a LEFT OUTER JOIN when there are more than two tables in the query.
>
>How can I workaround this problem?
--sb--