#typesofjoins #joinsinsql #variousjoinsinsql #varioustypesofjoinsinsql #innerjoin #leftjoin #rightjoin #crossjoin #fulljoin #topsqlinterviewquestions #advancedsqlinterviewquestions #sqlinterviewquestionsfordataanalysts #scenariobasedsqlinterviewquestions #dataanalystsqlinterviewquestions SQL Joins Interview Question: ===================================================== Number of Records for Inner Join Number of Records for Left Join Number of Records for Right Join Number of Records for Full Join Number of Records for Cross Join Logic : inner join : common records left join : inner join + remaining left table ruight join: inner join + remaining right table full join : inner join + remaining left and right cross : multiplication of 2 tables