Is this too simple? select distinct p.symbol, i.name from portfolio p, stockinfo i where p.symbol = i.symbol and p.type = '401k' and p.owner='jim' order by p.symbol
----- Tom Haapanen -- Software Metrics/Equitrac Corp. Advanced Printing Solutions -- http://www.metrics.com/ -----Original Message----- From: Mr. psm996 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 02 January, 2002 09:30 To: [EMAIL PROTECTED] Subject: SubSelect Workaround help 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