Table layout gets confused with same column names on multiple tables. Am I missing something?

If two tables in a query have the same column names, they must be distinguished using column alias names in order to use them both in a table component. For example:

SELECT FirstName as EmployeeName,

      FirstName as ManagerName 

FROM dbo.Employees A,

    dbo.Employees B 

where ReportsTo = EmployeeId

Not logged in. Log in, Register

By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo