(SQL Tutorial #14) INNER JOIN in SQL (INNER VS. OUTER JOIN)

Learn how to write queries with INNER JOIN in SQL. Learn the difference between INNER join and OUTER join. ► INNER JOIN Returns records that have matching values in both tables. ► Queries used in this video: 1. SELECT * FROM hr.employees; 2. Display country_id, country name, region id, region name from hr database select c.country_id, c.country_name, c.region_id, r.region_name from hr.countries c inner join hr.regions r on c.region_id=r.region_id; 3. Display All cities, country names from hr database select l.city, c.country_name from countries c inner join locations l on c.country_id=l.country_id; 4. Display the first name, last name, department number, and department name, for all employees for departments 80 or 40. select e.first_name, e.last_name, e.department_id, d.department_name from employees e inner join departments d on e.department_id=d.department_id where e.department_id in (80,40); ***▶️ means greater than & ◀️ means less than*** ► This video is a part of SQL for Beginners Tutorial series. ► See the PLAYLIST to learn more about SQL commands: https://www.youtube.com/playlist?list=PLArhmGag-BWoPLN8vNw9fPlHPwAVvN-hG 👍👍 👍PLEASE LIKE & SHARE THIS VIDEO with your friends to support us grow! 🔔🔔 🔔DON'T FORGET TO SUBSCRIBE to watch future tutorials https://www.youtube.com/channel/UCMEzw1tTTLLssZSVNPA18aQ TURN ON THE 🔔 BELL ICON TO GET UPDATES FIRST!📩📩📩 #InnerJoinSQL #InnerJoinAndOuterJoin