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
