AND orders.order_receipt_sent = 1 Could this have something to do with it? The rest of the query looks to be ok, unless I am overlooking something also.
----- Original Message ----- From: "Mike | NZSolutions Ltd" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Sunday, August 13, 2006 4:27 PM Subject: Checking multiple orders > Hi guys, > > My client wishes to see all customers that have made more than 1 order > from their website. What I have is the following... > > ---------------------------------------------- > SELECT orders.*, payment_authority.* > FROM orders LEFT OUTER JOIN payment_authority > ON orders.order_id = payment_authority.order_id > WHERE orders.order_id IN > ( > SELECT O.order_id FROM orders AS O > WHERE Exists ( > SELECT customer_id > FROM orders > WHERE orders.customer_id = O.customer_id > GROUP BY orders.customer_id > HAVING COUNT(orders.customer_id) > 1 > ) > ) > AND orders.order_receipt_sent = 1 > ORDER BY orders.customer_id > > ---------------------------------------------- > > Seems to work fine, pulls all multiple orders out - however there are > about 5 customers which come out that only appear once in the orders > database? > > Can anyone see anything I may not be doing correctly with this query? > > mike > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
