SQL diferent JOINs
sql joins is combine of rows from two or more tables based on common field between them. most common type of join is SQL INNER JOIN (simple join). there are some other different type of sql joins:
1. FULL JOIN ( full join returns rows from both table )
2. INNER JOIN ( inner join returns rows from both table as there is a match between the columns in both table )
3. LEFT JOIN ( left join returns rows from the left table with the matching rows in right table )
4. RIGHT JOIN( right join returns rows form the right table with the matching rows in left table )
1. FULL JOIN ( full join returns rows from both table )
2. INNER JOIN ( inner join returns rows from both table as there is a match between the columns in both table )
3. LEFT JOIN ( left join returns rows from the left table with the matching rows in right table )
4. RIGHT JOIN( right join returns rows form the right table with the matching rows in left table )
-
David Beroff -
Thanks
SignaturePut MY voice on YOUR video: AwesomeAmericanAudio.com{{ DiscussionBoard.errors[10542702].message }} -