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:223396 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
