[EMAIL PROTECTED] wrote:
Hi,Try something like:
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
select
MarketData.*
from
MarketData inner join Contacts
on MarkerData.CustID=Contacts.ContactID
where
Contacts.CustID=1
MySQL doesn't currently support sub-selects. It will in version 4.1, which I've been told will be out later this year.
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
