> The following query is not allowed using my hosts version of MySQL:
You could do that with some nasty left join statements (untested):
SELECT cus.Customer_ID
FROM order_no AS ord
INNER JOIN customers AS cus ON (ord.Customer_ID = cus.Customer_ID)
LEFT JOIN users AS us ON (us.Customer_ID = cus.Customer_ID)
LEFT JOIN order_no AS ord2 ON (ord2.Customer_ID = cus.Customer_ID)
LEFT JOIN account AS acc ON (acc.Customer_ID = cus.Customer_ID)
WHERE ord.Order_No = #Order_No#
AND ord2.Order_No <> ord.Order_No
AND cus.User_ID = 0
AND us.Customer_ID IS NULL
AND ord2.Customer_ID IS NULL
AND acc.Customer_ID IS NULL
Tim.
--
-------------------------------------------------------
Badpen Tech - CF and web-tech: http://tech.badpen.com/
-------------------------------------------------------
RAWNET LTD - independent digital media agency
"We are big, we are funny and we are clever!"
New site launched at http://www.rawnet.com/
-------------------------------------------------------
This message may contain information which is legally
privileged and/or confidential. If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
-------------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199890
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
