Whats wrong with this query?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rashed
Forum Newbie
Posts: 17
Joined: Fri Jun 06, 2003 6:27 am
Location: Islamabad, Pakistan.

Whats wrong with this query?

Post 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' )
[]InTeR[]
Forum Regular
Posts: 416
Joined: Thu Apr 24, 2003 6:51 am
Location: The Netherlands

Post by []InTeR[] »

What is your mysql version?
rashed
Forum Newbie
Posts: 17
Joined: Fri Jun 06, 2003 6:27 am
Location: Islamabad, Pakistan.

Post by rashed »

[]InTeR[] wrote:What is your mysql version?
its 3.23.52. But its standard SQL query
User avatar
Wayne
Forum Contributor
Posts: 339
Joined: Wed Jun 05, 2002 10:59 am

Post by Wayne »

sub selects are only supported in mysql 4.1
Last edited by Wayne on Fri Jun 06, 2003 7:45 am, edited 1 time in total.
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

rashed
Forum Newbie
Posts: 17
Joined: Fri Jun 06, 2003 6:27 am
Location: Islamabad, Pakistan.

Post by rashed »

Thak you Wayne
but i think sub selects are De-facto standard (Well Known, famous )
User avatar
delorian
Forum Contributor
Posts: 223
Joined: Sun May 04, 2003 5:20 pm
Location: Olsztyn, Poland

Post 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 :wink: so sub queries will be able from 4.1
Post Reply