Not that anyone cares, but i love to see queries that are neatly written and legible like the one below.... even though it is long, I can read it!!! nice!!
----- Original Message ----- From: "Phillip B" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 11:01 AM Subject: Re: Can I inner join and outer join in the same query? > Here is the query. > > SELECT > c.family_id, > c.name as cname, > boats.fk_family_id, > boats.boat_id, > boats.name, > boats.length, > boats.order_by, > bxsMaxHP.amount AS maxhp, > bxsPersons.amount AS persons, > bxsBeam.amount AS beam, > bxc.copy > FROM > boats > INNER JOIN > boats_xref_specs bxsMaxHP > ON > boats.boat_id = bxsMaxHP.fk_boat_id > INNER JOIN > boats_xref_specs bxsPersons > ON > boats.boat_id = bxsPersons.fk_boat_id > INNER JOIN > boats_xref_specs bxsBeam > ON > boats.boat_id = bxsBeam.fk_boat_id > INNER JOIN > boats_xref_copytypes bxc > ON > boats.boat_id = bxc.fk_boat_id > INNER JOIN > boatfamily C ON boats.fk_family_id = C.family_id > WHERE > (boats.fk_family_id = 27) > AND > (boats.modyear = 2004) > AND > (bxsMaxHP.fk_spec_id = 7) > AND > (bxsPersons.fk_spec_id = 106) > AND > (bxsBeam.fk_spec_id = 102) > AND > (bxc.fk_copytype_id = 2) > > Phillip B. > > www.LoungeRoyale.com > www.FillWorks.com > ----- Original Message ----- > From: "Raster, Tim" <[EMAIL PROTECTED]> > To: "SQL" <[EMAIL PROTECTED]> > Sent: Thursday, September 04, 2003 9:45 AM > Subject: RE: Can I inner join and outer join in the same query? > > > > 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:> Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
