You will be performing a lot of joins in your career as a data analyst. Also, Joins are really important in SQL and you should practice and master them. Let's discuss the difference between inner join and left join as you will be using them often as a data analyst. 𝗜𝗻𝗻𝗲𝗿 𝗝𝗼𝗶𝗻: It retrieves rows that are common in both tables. 𝗘𝘅𝗮𝗺𝗽𝗹𝗲: SELECT e.emp_id , s.salary FROM employees as e INNER JOIN salary as s using(emp_no) 𝗟𝗲𝗳𝘁 𝗝𝗼𝗶𝗻: It retrieves all the rows from the left table and common rows from the right table. It shows null in the right rows when there is no match. 𝗘𝘅𝗮𝗺𝗽𝗹𝗲: SELECT e.emp_id , s.salary FROM employees as e LEFT JOIN salary as s using(emp_no) Enjoy. Follow for more! #SQL #DataAnalytics #DataAnalysis #SQLJoins #InnerJoin #LeftJoin #SQLLearning #DataSkills #TechSkills #DataAnalystTips #GlobalDataAnalytics #WorldwideDataInsights #SQLGlobal #AnalyticsCommunityGlobal #DataAnalystWorldwide #USDataAnalytics #LearnAnalyticsUSA #SQLSkillsUSA #DataAnalystUSA #AnalyticsCommunityUSA #UKDataAnalytics #SQLUK #LearnDataToolsUK #BritishDataAnalyst #AnalyticsCommunityUK #EuropeDataAnalytics #SQLSkillsEurope #DataInsightsEurope #EuropeanDataAnalyst #AnalyticsCommunityEurope #SingaporeDataAnalytics #SQLSingapore #LearnSQLSG #AnalyticsInSingapore #DataInsightsSG