Re: statement doesnt work onMySQL

2002-11-06 Thread Daniel Kasak
[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

RE: statement doesnt work onMySQL

2002-11-06 Thread [EMAIL PROTECTED]
: [EMAIL PROTECTED] Date: Wed, 6 Nov 2002 20:59:06 EST To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: statement doesnt work onMySQL 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.Cust

statement doesnt work onMySQL

2002-11-06 Thread Sam4Software
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