IN() Function problem

[Anon]

I have the following tables:

Order Details:

OrderID
SKU

Products:

ProductID
SKU
Price
Name

And when I try the following statement in MySQL version 3.22.32 it doesn't work:

select d.OrderID from OrderDetails d
where d.SKU in
(select p.SKU from Products p where
p.Price > 0)

I tried running this in MySQL Front 2.2 and it said "Syntax error near: select p.SKU from...".

Any ideas, this should be very simple I would hope.

Thanks in advance,
-Jon

[bastien]

MySQL does not support subselect statements...you will need to break it into two statements and DB calls...

Bastien

[Anon]

I don't see why you need the subselect at all, doesn't this work?

select distinct d.OrderID
from OrderDetails d, Products p
where d.SKU = p.SKU
and p.Price > 0