Tech Junkie Blog - Real World Tutorials, Happy Coding!: SQL: RIGHT JOIN

Thursday, June 3, 2021

SQL: RIGHT JOIN

RIGHT JOIN works like the INNER JOIN, it just returns all the records that are on the right side of the = sign on the RIGHT JOIN clause. For example let's say you want to get a record of all customers who orders a certain product.



  RIGHT JOIN SQL Query
You will use the RIGHT JOIN by query all the orders in the Orders table then linking it to the OrderDetails table and then eventually linking it to the Products table. 

SELECT c.CompanyName,c.ContactName,c.ContactTitle,od.OrderID,p.ProductID,p.ProductName
FROM Customers c
RIGHT JOIN Orders o ON o.CustomerID = c.CustomerID
RIGHT JOIN [Order Details] od ON o.OrderID = od.OrderID
RIGHT JOIN Products p ON p.ProductID = od.ProductID

Here are the results:

RIGHT JOIN SQL Query Result
You can filter the results further by adding a WHERE clause for a specific product id. 
SELECT c.CompanyName,c.ContactName,c.ContactTitle,od.OrderID,p.ProductID,p.ProductName
FROM Customers c
RIGHT JOIN Orders o ON o.CustomerID = c.CustomerID
RIGHT JOIN [Order Details] od ON o.OrderID = od.OrderID
RIGHT JOIN Products p ON p.ProductID = od.ProductID 
WHERE p.ProductID = 33
Here are the results:
RIGHT JOIN SQL Query To Find Results With A Specific ID


at

9 comments:

  1. FrancisOctober 24, 2019 at 12:29 AM

    I want to show my thanks to the writer just for rescuing me from this matter. After exploring through the online world and meeting basics which were not powerful, I figured my entire life was done. Living without the approaches to the issues you have fixed all through your report is a critical case, and the ones that would have adversely affected my career if I had not discovered your website. Your good natural talent and kindness in playing with a lot of things was tremendous. I am not sure what I would've done if I hadn't encountered such a point like this. It’s possible to at this point look ahead to my future. Thanks so much for your reliable and amazing guide. I will not think twice to recommend the sites to anyone who would need support on this issue.Refer best essay writing service to get any help in writing.

    ReplyDelete
  2. Tripu DesignNovember 30, 2019 at 6:02 AM

    This is an amazing blog, thank you so much for sharing such valuable information with us.
    Visit for best logo and brochure designing services at- brochure designer in delhi.
    graphic designer in delhi
    freelance graphic designer in delhi
    freelance graphic designer in delhi ncr
    freelance graphic designer in noida
    freelance logo designer in delhi
    freelance logo designer in delhi ncr
    freelance web designer in delhi ncr
    freelance website designer in delhi ncr
    freelance designer in delhi
    freelance website designer in delhi
    freelance web designer in delhi
    freelance graphic designer services in delhi
    freelancer graphic designer services in delhi ncr
    freelancer graphic designer services in delhi
    freelancer graphic services in delhi ncr
    freelancer logo services in delhi
    freelancer logo services in delhi ncr
    freelancer web designer services in delhi ncr
    freelancer web designer services in delhi
    freelance web designer services in delhi
    freelance website designer services in delhi
    freelance website designer services in delhi ncr
    freelance logo designer service in delhi
    freelance logo designer service in delhi ncr
    logo designer in delhi
    brochure design in delhi
    logo design in delhi
    freelance logo design in delhi
    freelance logo designer in gurgaon
    freelance logo designer in noida

    ReplyDelete
  3. TNK Design DeskDecember 11, 2019 at 6:11 AM

    This comment has been removed by the author.

    ReplyDelete
  4. fawNovember 16, 2020 at 8:33 AM

    ساندویچ پانل
    کشنده فاو
    ساندویچ پانل سقفی
    کامیون اقساطی
    قیمت ساندویچ پانل

    ReplyDelete
  5. bogsspecialistMarch 11, 2021 at 5:05 AM

    I was more than happy to uncover this great site. I need to to thank you for your time due to this fantastic read!!
    I definitely enjoyed every bit of it and I have you bookmarked to see new information on your blog.
    Classified Ads WordPress Theme

    ReplyDelete
  6. bogsspecialistMarch 11, 2021 at 5:06 AM


    I was more than happy to uncover this great site. I need to to thank you for your time due to this fantastic read!!
    I definitely enjoyed every bit of it and I have you bookmarked to see new information on your blog.
    Freelance Marketplace WordPress Theme

    ReplyDelete
  7. PanelOnlineSeptember 22, 2021 at 8:30 AM

    ساندویچ پانل


    سوله یو بی ام


    دیوار پیش ساخته

    ReplyDelete
  8. bimeh-samanSeptember 26, 2021 at 2:38 AM

    http://www.bimeh-saman.com

    ReplyDelete
  9. AnonymousFebruary 16, 2022 at 7:17 AM

    Thank you for sharing this information. Amazing Article!
    If you are looking for machine learning courses in Bangalore, visit Learnbay.co
    website to check details related to the data science online courses and online machine learning course.

    ReplyDelete