I am new to Discoverer. I have some confusion.
1. Is it possible use different Alias for same table while creating Worksheet?
Need this to produce different joins.
SELECT C1.Name, C2.Remarks
FROM Clients C1,
WHERE C1.Client_Id = T.Client_Id AND C2.Client_Id = S.Client_Id
2. How should I use Column Alias to show as a customised column header in the Worksheet?
SELECT Client_Default_Name AS Name FROM Clients
Thanks in advance.
the worksheet sql is always structured according to the EUL (end user layer) . if you have used two clients tables and created a join to different tables then the sql will be generated as per your requirement . there is no way we can have Discoverer create a sql like that . if you are so interested with the sql . you can create a custom folder in the business area and paste the sql and create a report on top of the custom folder .
you can always edit the heading in the discoverer plus workbooks as per your requriement
hope this helps