OUTER JOIN in SQL

Công Nghệ



Join Discussion:

IMPORTANT LINKS:
1) Official Website:
2) Virtual GATE:
Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share!

Our Social Media Links:
Facebook Page:
Facebook Group:
Google+ Page:

Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.

Nguồn: https://bus-rush.info/

Xem thêm bài viết khác: https://bus-rush.info/cong-nghe/

21 thoughts on “OUTER JOIN in SQL

  1. So what is the difference between full join and full outer join, left join and left outer join, right join and right outer join? 😀

  2. I just wandering if we using (+) operator to solve left outer join and right outer join \

    Right Outer-join :
    select L.loan_no , branch , amt , cust_name , B.loan_no
    from loan L , borrower
    where B.loan_no = L.loan_no(+) ;

    Left Outer_join :
    select L.loan_no , branch , amt , cust_name , B.loan_no
    from loan L , borrower
    where B.loan_no(+) = L.loan_no ;

    could u please tell if that is right , and how we can use full outer join using (+) operator . And thank u

Leave a Reply

Your email address will not be published. Required fields are marked *