68 334
Assignments Done
Successfully Done
In November 2018

Answer to Question #76507 in Databases | SQL | Oracle | MS Access for J

Question #76507
What is S an alias of in the query below?
select orderid, salespersonname
(select salespersonid, salespersonname, SalespersonTelephone
from Salesperson_T where SalesTerritoryID = 1) S
join Order_T O
on O.SalespersonID = S.SalespersonID

An Outer Join

A Derived Table

A Union

A Join
Expert's answer
Derived Table

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!


No comments. Be first!

Leave a comment

Ask Your question

Privacy policy Terms and Conditions