Revision as of 18:04, 5 November 2009 by Admin (Talk | contribs)
(diff) ← Older revision | Current revision (diff) | Newer revision → (diff)


クエリーで 2 つの表に同じ列名が存在する場合、表コンポーネントで両方を使用するためには、列の別名を使用してそれらを区別する必要があります。次に、例を示します。

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