Re: Every derived table must have its own alias
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; )