Subquery

[Balaji. M.]

I have the following table structures;

create table Platform (
PlatformId mediumint Primary Key auto_increment,
PlatformName varchar(25),
ProjectName varchar(50)
);

create table PlatformSubType (
PlatformSubTypeId mediumint Primary Key auto_increment,
PlatformId mediumint,
PlatformSubTypeName varchar(50)
);

When I query this way, its giving error as follows
select * from PlatformSubType where PlatformId IN
(select PlatformId from Platform where PlatformName="c1200" and ProjectName ="Fluorine");

You have an error in your SQL syntax near 'select Platform.PlatformId from Platform where PlatformName="c1200" and ProjectN' at line 2
Thanks in Advance.

[Aggro]

Balaji. M. wrote:

I have the following table structures;
create table Platform ( PlatformId mediumint Primary Key auto_increment,
PlatformName varchar(25), ProjectName varchar(50) );
create table PlatformSubType ( PlatformSubTypeId mediumint Primary Key
auto_increment, PlatformId mediumint, PlatformSubTypeName varchar(50) );
When I query this way, its giving error as follows select * from
PlatformSubType where PlatformId IN (select PlatformId from Platform
where PlatformName="c1200" and ProjectName ="Fluorine");
You have an error in your SQL syntax near 'select Platform.PlatformId
from Platform where PlatformName="c1200" and ProjectN' at line 2

Subqueries are supported from version 4.1, what version are you using?