what are joins? What is the left join and inner?

hi narendra, JOIN is same as INNER JOIN and means to only show records common to both tables. Whether the records are common is determined by the fields in join clause. For example: FROM t1 JOIN t2 on t1.ID = t2.ID Means show only records where the same ID value exists in both tables. LEFT JOIN

Hi My Sql is a RDBMS , For better performance Data in different table are related by keys . SQL Joins are used to relate information in different tables. A Join condition is a part of the sql query that retrieves rows from two or more tables . All the best !