Wednesday, February 22, 2012

JOIN Operation In MYSQL


LEFT JOIN Operation IN MYSQL

1. Select All row from Table Left (Table 1) even if there are no matches in the right table (table2).
2. select All Row from Right Table (Table2) who is match in left Table ;


SELECT * FROM Table1 LEFT JOIN Table2 ON Table1.colName=Table2.colName





RIGHT JOIN Operation IN MYSQL

1. Select All row from RIGHT Table (Table 2) even if there are no matches in the left table (table1).
2. select All Row from left Table (Table1) who is match in RIGHT Table ;


SELECT * FROM Table1 RIGHT JOIN Table2 ON Table1.colName=Table2.colName




FULL JOIN Operation IN MYSQL

1. Select All row from Both Table(Table1 , Table2)


SELECT * FROM Table1 FULL JOIN Table2 ON Table1.colName=Table2.colName



No comments:

Post a Comment

If you Satisfied , Please Leave a comment