Not directly, MySql does not support sub selects yet..... HTH
Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ----------------------------------------------- > -----Original Message----- > From: Arul [mailto:[EMAIL PROTECTED]] > Sent: 26 June 2002 10:33 > To: MySQL > Cc: [EMAIL PROTECTED] > Subject: How can this Oracle Query converted to MySQL > > > SELECT > U.UserID > FROM > Transaction_Data T, Rfq_Data R ,Company C > WHERE > T.TransactionID = R.TransactionID AND > (R.Industryid=1 or R.IndustryID IN (SELECT IndustryID FROM > Company_Industries CI WHERE CI.CompanyID = C.CompanyID)) > > > > > This is to Pass the Mail Server : sql,query > > > > --------------------------------------------------------------------- > 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