[EMAIL PROTECTED] wrote:
Hi,
I have the following SQL statement that works fine on Access but it doesn't
work on MySQL...
select MarketData.* FROM MarketData where MarketData.CustID IN
(SELECT ContactID from Contacts where CustID =1)
Any advise please??
Regards,
Sam
Try something like
Sub-Selects do not work on MySQL Yet.
Wait for Version 4.1. I am waiting!
In the mean time you could do this
SELECT * FROM MarketData INNER JOIN Contacts ON MarketData.CustID =
Contacts.CustID WHERE Contacts.CustID = 1;
HTH
JFernando
** sql ***
Original Message:
-
From:
