On Mon, 12 Apr 1999 17:14:39 +0000, Thomas Booms EDV wrote:
>Is this function not implemented ?
>How can I do it?
I've used SELECT value3 FROM table3, then just built 'res1','res2', ...
in the application and used it in the next query:
SELECT value1 from table2 WHERE value2 IN ('res1','res2',...)
The MySQL folks are working on subselects, though.
If the list of value3 matches is very long, you could achieve the same
with a JOIN between table1 and table3.
(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)