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:249687 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4