Depending on what you're trying to do, you SHOULD be able to inner-join to your heart's content, and then left-join off of those. But you CANNOT inner-join a table, then left-join that table to another, and then inner-join that last table to yet another.
Show us your query... -----Original Message----- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 09:38 To: SQL Subject: Can I inner join and outer join in the same query? I'm writing a query that requires a few joins in it. If I use all inner joins, the query works but leaves out the records that are missing info in joined tables. If I write is using left outer joins it wont return any records at all. With that said, it leads me to believe that you cant mix your join types in a query and that multiple outer joins wont work at all. Does this sound write? Phillip B. www.LoungeRoyale.com www.FillWorks.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> Get the mailserver that powers this list at http://www.coolfusion.com
