List:General Discussion« Previous MessageNext Message »
From:Tomislav Petrovic Date:April 12 1999 5:41pm
Subject:Re: Problems with in
View as plain text  
>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.......

Thread
Problems with inThomas Booms EDV12 Apr
Re: Problems with inFred Lindberg12 Apr
Re: Problems with inTomislav Petrovic12 Apr