What are the differences between the joining and subquery ap

What are the differences between the joining and subquery approaches to manipulating multiple tables in SQL?

Solution

Joins SubQuery Join works on multiple tables and extract data based on primary and foreign keys SubQuery uses Select statement . This Select query is dependent on Subquery result. Joins are faster,less lag time SubQuery is relatively slow,more lag time Not readable comparatively SubQuery is easily readable. used to return rows used to return scalar value or row set