atsv1.png
  • Home

  • Offerings & Downloads

  • FAQ

  • Anubhav's Learning Series

  • Next Batchs

  • Testimonials

  • Contact Us

  • Become a trainer

  • Testimonials

    Use tab to navigate through the menu items.

    www.anubhavtrainings.com

    Mail us on contact@anubhavtrainings.com

    Follow excellence with sheer passion

    s4hana tutorial.png
    Mail us
    To see this working, head to your live site.
    • All Posts
    • My Posts
    anubhavabap
    Oct 01, 2019

    join vs multiple tables

    in Anubhav 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 comments
    0
    Comments

    Share Your ThoughtsSign up to leave a comment.

    0 comments

    Mail us at contact@anubhavtrainings.com