Follow excellence with sheer passion

  • Home

  • Offerings & Downloads

  • FAQ

  • Testimonials

  • Contact Us

  • Testimonials

    To see this working, head to your live site.
    1. SAP UI5/Fiori Forum
    2. join vs multiple tables
    Search
    Shital Anushka
    Aug 20, 2019

    join vs multiple tables

    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 comments
    0