Uses For Derived Tables

(Robert Marda) A derived table is a select statement inside parenthesis, with an alias, used as a table in a join. A simple example is: SELECT a.LastName, b.State FROM UserTable a INNER JOIN (SELECT UserID, State FROM AddressTable) b ON a.UserID = b.UserID

Read More - Register for Free Membership