Not sure what is up. It's kinda difficult without having the actual
tables set up. Can you post the entire query you have again?
One way to troubleshoot would be to build one join at a time. Start
with the Customer table, join Orders and test; Then join OrderItems
and test, etc.
Matt
On Tue, Jun 3, 2008 at 10:18 AM, Jason Congerton
<[EMAIL PROTECTED]> wrote:
> Hi
>
> Thanks for your replys have tried the code and am getting the following error,
>
> Syntax error (missing operator) in query expression
> 'retailCustomer.retailCustID = retailOrders.ocustID LEFT JOIN retOrderItems
> ON retailOrders.orderNo = retOrderItems.piOrderNo LEFT JOIN products ON
> retOrderItems.piProductID = products.productID'.
>
> Tried troubleshooting but to no avail.
>
> Jason
>
>
>>Try this. Note that if you use a where on one of the left joined
>>tables it kind of negates the "left" part of that. One way around this
>>is to add "or x is null"
>>
>>FROM retailCustomer
>>LEFT JOIN retailOrders ON retailCustomer.retailCustID = retailOrders.ocustID
>>LEFT JOIN retOrderItems ON retailOrders.orderNo = retOrderItems.piOrderNo
>>LEFT JOIN products ON retOrderItems.piProductID = products.productID
>>WHERE 0=0
>><cfif IsDefined('FORM.scCounty') AND FORM.scCounty NEQ "">
>>AND (retCustCounty) LIKE '%#scCounty#%'</cfif>
>><cfif IsDefined('FORM.scpdName') AND FORM.scpdName NEQ 1>
>>AND (products.productID) = #scPdname# OR products.productID IS NULL
>></cfif>
>>
>>
>>On Tue, Jun 3, 2008 at 4:15 AM, Jas
>>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306701
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
