Would anyone know how the query below could be written to support MySQL?
my $stmt = qq{select distinct p.symbol, i.name
from portfolio p, stockinfo i
where p.symbol = i.symbol };
$stmt .= qq{and p.symbol in
(select distinct symbol from portfolio where $res)
psm 996 --
The real question is:
Does MySQL support sub query, the short answer is 3.x.x does not,
4.x.x is supposed to.
The longer answer(and work arounds) to the 3.x.x question can be found here:
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
David