MySQL Forums
Forum List  »  Newbie

Re: Every derived table must have its own alias
Posted by: senthil kumar
Date: July 15, 2005 03:49AM

Thankx Mr. Roland,

I am using 3 sub queries when i put alias at the last line it shows the same error..

the code

SELECT NAME, TITLE, FIRSTNAME, MIDDLENAME, LASTNAME,SUFFIX, COMPANYNAME,
FILEAS, BUSINESSTELEPHONENUMBER, BUSINESSFAXNUMBER, HOMETELEPHONENUMBER,
MOBILETELEPHONENUMBER, CONTACTID

FROM
(SELECT RECORDTYPE, NAME, TITLE, FIRSTNAME, MIDDLENAME, LASTNAME, SUFFIX,
COMPANYNAME, FILEAS, BUSINESSTELEPHONENUMBER, BUSINESSFAXNUMBER, HOMETELEPHONENUMBER,
MOBILETELEPHONENUMBER, ROWNUM AS ROW_NUM, CONTACTID

FROM
(SELECT 'C' AS RECORDTYPE,
CONCAT(LASTNAME, ', ', FIRSTNAME) AS NAME,
TITLE, FIRSTNAME, MIDDLENAME, LASTNAME, SUFFIX, COMPANYNAME, FILEAS,
BUSINESSTELEPHONENUMBER, BUSINESSFAXNUMBER, HOMETELEPHONENUMBER,
MOBILETELEPHONENUMBER, CONTACTID
FROM CONTACTDETAILS WHERE (USERID = 9 )) AS C1
WHERE ROWNUM <= 1 )
WHERE ROW_NUM >= 1; )

Options: ReplyQuote


Subject
Written By
Posted
Re: Every derived table must have its own alias
July 15, 2005 03:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.