Forum Posts

Shital Anushka
Aug 20, 2019
In SAP UI5/Fiori Forum
we get same results using both the queries which are written below,then why to use joins instead of selecting columns from multiple tables with where condition as follows SELECT OrderID,CustomerName FROM Orders,Customers where Orders.CustomerID = Customers.CustomerID; with joins eample SELECT Orders.OrderID, Customers.CustomerName FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;
0
0
71
Shital Anushka
More actions