Page 1 of 1
Whats wrong with this query?
Posted: Fri Jun 06, 2003 6:27 am
by rashed
SELECT sid
FROM campaign
where vid
in (
SELECT id
FROM Vendor
where login = 'abc'
)
MySql Says,
You have an error in your SQL syntax near 'SELECT id FROM Vendor where login='abc' )
Posted: Fri Jun 06, 2003 6:49 am
by []InTeR[]
What is your mysql version?
Posted: Fri Jun 06, 2003 7:08 am
by rashed
[]InTeR[] wrote:What is your mysql version?
its 3.23.52. But its standard SQL query
Posted: Fri Jun 06, 2003 7:28 am
by Wayne
sub selects are only supported in mysql 4.1
Posted: Fri Jun 06, 2003 7:35 am
by twigletmac
Posted: Fri Jun 06, 2003 7:49 am
by rashed
Thak you Wayne
but i think sub selects are De-facto standard (Well Known, famous )
Posted: Fri Jun 06, 2003 4:40 pm
by delorian
rashed wrote:Thak you Wayne
but i think sub selects are De-facto standard (Well Known, famous )
But MySQL has its delays in standards

so sub queries will be able from 4.1