Question:A steel production company has two sales outlets. Both outlets are maintaining their data separately in servers SVA and SVD. Both outlets use the same structure for the Sales table. Which method will you use to create a combined sales report for both the outlets? 

A Select * from SVA.Sales join SVD.Sales 

B Select * from SVA.Sales union all SVD.Sales 

C select * from SVA.Sales,SVD.Sales 

D None of these above 

+ Answer
+ Report
Total Preview: 572

Copyright © 2024. Powered by Intellect Software Ltd