Just keep writing LEFT OUTER JOIN FROM tblprod_SKUS LEFT OUTER JOIN tblSKUoptions ON tblprod_SKUS.SKUID = tblSKUoptions_rel.optionSKUID LEFT OUTER JOIN tblproducts ON tblprod_SKUS.SKU_prodID = tblproducts.prodID LEFT OUTER JOIN tblshiptimes ON tblprod_SKUS.shiptimeID = tblshiptimes.shiptimeID WHERE tblprod_SKUS.SKUID = #ARGUMENTS.SKUID# don't forget the cfqueryparam :)
HTH, t On 11/6/05, Will Tomlinson <[EMAIL PROTECTED]> wrote: > > I'm running a query on product SKUS for and edit form. The problem is I > need to return a SKU even if there aren't options available for it. Right > now it doesn't. Here's my query as of now: > > <cfquery name="getskuinventory" datasource="#VARIABLES.dsn#"> > SELECT tblprod_SKUS.SKUID, tblprod_SKUS.merchSKUID, > tblprod_SKUS.SKU_prodID, tblprod_SKUS.SKUprice, > tblprod_SKUS.SKUsaleprice, tblprod_SKUS.SKUqtyinstock, > tblprod_SKUS.shiptimeID, tblshiptimes.shiptimeID, > tblshiptimes.shiptimetext, tblSKUoptions_rel.optionID, > tblSKUoptions_rel.optionSKUID,tblSKUoptions_rel.option_optionID, > tblproducts.prodID, tblproducts.prod_MerchID, tblproducts.prodname > FROM tblprod_SKUS, tblSKUoptions_rel, tblproducts,tblshiptimes > WHERE tblprod_SKUS.SKUID = #ARGUMENTS.SKUID# > AND tblprod_SKUS.SKUID = tblSKUoptions_rel.optionSKUID > AND tblprod_SKUS.SKU_prodID = tblproducts.prodID > AND tblprod_SKUS.shiptimeID = tblshiptimes.shiptimeID > </cfquery> > > Now I've used left outer joins on just two tables like this: > > <cfquery name="getinventory" datasource="#VARIABLES.dsn#"> > SELECT tblproducts.prodID, tblproducts.prod_MerchID, tblproducts.prodname, > tblprod_SKUS.SKUID, tblprod_SKUS.merchSKUID, tblprod_SKUS.SKU_prodID, > tblprod_SKUS.SKUprice > FROM tblproducts LEFT OUTER JOIN tblprod_SKUS > ON tblproducts.prodID = tblprod_SKUS.SKU_prodID > </cfquery> > > But how would I convert the 1st query (4 tables) to a full left join. > > Thanks much, > bday boy .CF Will > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223398 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
