Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
rashed
- Forum Newbie
- Posts: 17
- Joined: Fri Jun 06, 2003 6:27 am
- Location: Islamabad, Pakistan.
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
-
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.
-
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 )
-
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

so sub queries will be able from 4.1