atsv1.png
  • Home

  • Offerings & Downloads

  • FAQ

  • Anubhav's Learning Series

  • Next Batchs

  • Testimonials

  • Contact Us

  • Become a trainer

  • Testimonials

    www.anubhavtrainings.com

    Mail us on contact@anubhavtrainings.com

    Follow excellence with sheer passion

    s4hana tutorial.png
    Mail us
    1. Anubhav Forum
    2. join vs multiple tables
    Search
    anubhavabap
    Oct 1, 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

    Mail us at contact@anubhavtrainings.com