From: Tomislav Petrovic
Date: April 12 1999 5:41pm
Subject: Re: Problems with in
List-Archive: http://lists.mysql.com/mysql/1714
Message-Id: <006e01be850b$cb992b60$6880c6c1@tomy>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>I use mysql with php3,
>
>When I try to do the following,
>select value1 from table1 where value2 in (select value3 from table3),
>I get an syntax error.

Such subselect are not yet implemented in mysql.......
>How can I do it?


select value3 from table3 

save these in php array.....

select value1, value2 from table1......

print out, by using php if or something, those who have value2 equal to 
some value in above mentioned array......

Tomy.......