SQL Query

[Balaji Muthuvarathan]

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.