sql question in php

Anon

hi all,
i am doing a complicated query.
it uses "IN" keyword.
e.g
select * from product where
product_no IN ('1','2',....)

of cos that simple ('1','2',...)
acutally it querys anothers table.
select * from product where
product_no IN (select product_no from seller)

it works when i use ('1','2',...) but not when use (select product_no from seller)
my question is how to convert (select product_no from seller) to ('1','2',...)
in php?
Alex

reagent

Are you using mySQL? If so, mySQL does NOT support the use of sub queries..

try using
select *
from products P,
seller S
where P.product_no = S.product_no

hth.
p

jmakeig

Sub-selects are not available in mySQL (I'm assuming that's the db you're using). See http://www.mysql.com/doc///M/i/Missing_Sub-selects.html

Justin

penny336 wrote:

hi all,
i am doing a complicated query.
it uses "IN" keyword.
e.g
select * from product where
product_no IN ('1','2',....)

of cos that simple ('1','2',...)
acutally it querys anothers table.
select * from product where
product_no IN (select product_no from seller)

it works when i use ('1','2',...) but not when use (select product_no from seller)
my question is how to convert (select product_no from seller) to ('1','2',...)
in php?
Alex

Anon

yes.
i am using mysql,
is ur query
select *
from products P,
seller S
where P.product_no = S.product_no

same as my "IN" query??

reagent

I don't know what you are trying to achieve with your IN query, but that query will select all rows from products and sellers where they have the same ids

give it a try.