Hi Arul, maybe copying the columns into a temporary table might do the job. I don't know how big your tables are, if performance might be a problem.
The following statements should create the query you wanted: /*creating temporary table*/ CREATE TABLE tmp_Information ( TYPENAME (any typ-definition varchar,int???) ); /*inserting rows for company information*/ INSERT INTO tmp_Information SELECT CT.Company_Type as TYPENAME FROM RFQ_Details RD, Company_Type CT WHERE RD.RFQID = 4 AND RD.SEARCH_Type = 'COMPANY' AND Company_TypeID = RD.TypeID; /*inserting rows for user information*/ INSERT INTO tmp_Information SELECT UT.USER_Type as TYPENAME FROM RFQ_Details RD, User_Type UT WHERE RD.RFQID = 4 AND RD.SEARCH_Type = 'USER' AND User_TypeID = RD.TypeID; /*do whatever you want with the rows of the union*/ SELECT TYPENAME FROM tmp_Information; /*erase the temporary table*/ DROP TABLE tmp_Information Hopes that helps. Take care Andreas > -----Ursprüngliche Nachricht----- > Von: Arul [mailto:[EMAIL PROTECTED]] > Gesendet: Dienstag, 2. Juli 2002 11:04 > An: MySQL > Betreff: How do we make this query work in 3.23.51 > > > Hi > > I had written a query which executes in MySql 4.0.1 > But this is not working in 3.23.51 coz i had used Union > function in the > query which is not supported by 3.23.51 > > So any idea how this can be made to work on 3.23.51. I need > to have only one > Column in the result as TYPENAME > > SELECT > CT.Company_Type as TYPENAME > FROM > RFQ_Details RD, Company_Type CT > WHERE > RD.RFQID = 4 > AND RD.SEARCH_Type = 'COMPANY' > AND Company_TypeID = RD.TypeID > > UNION > > SELECT > UT.USER_Type as TYPENAME > FROM > RFQ_Details RD, User_Type UT > WHERE > RD.RFQID = 4 > AND RD.SEARCH_Type = 'USER' > AND User_TypeID = RD.TypeID > > --------------------------------------------------------------------- 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