Hi Paul, There is no direct way to make a string by concatinating strings of different columns. But your problem can be solved in a different way.
select distinct p.symbol, i.name from portfolio p, portfolio pp, stockinfo i where pp.type = '401k' AND pp.owner = 'jim' and p.symbol = i.symbol and p.symbol = pp.symbol order by p.symbol; Hope it works for you Anvar At 02:29 PM 02/01/2002 +0000, you wrote: >How would one load the results of the following query into a one line >comma separated list so that it could be then included with an IN expr to >get around the lack of subselect in MySQL > >select distinct symbol from portfolio where type='401k' AND owner='jim' > > > >select distinct p.symbol, i.name from portfolio p, >stockinfo i where p.symbol = i.symbol and p.symbol in >(string name) order by symbol > >Thanks. >Happy New Year >Paul > > > > > > >_________________________________________________________________ >Chat with friends online, try MSN Messenger: http://messenger.msn.com > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php