Not directly, MySql does not support sub selects yet.....
HTH
Peter
-----------------------------------------------
Excellence in internet and open source software
-----------------------------------------------
Sunmaia
www.sunmaia.net
in...@sunmaia.net
tel. 0121-242-1473
-----------------------------------------------
-----Original Message-----
From: Arul [mailto:arul...@calsoft.co.in]
Sent: 26 June 2002 10:33
To: MySQL
Cc: ja...@lists.mysql.com
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
To request this thread, e-mail <mysq...@lists.mysql.com>
To unsubscribe, e-mail
<mysql-unsubscribe-peter=sunm...@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
5 messages in com.mysql.lists.javaRE: How can this Oracle Query convert...