Thursday, 20 October 2011
SQL INNER JOIN
03:15
SQL INNER JOIN
03:15 / 0 Comments
The INNER JOIN keyword return rows when there is at least one match in both tables. SELECT column_nameFROM table_name1INNER JOIN table_name2ON table_name1.column_name=table_name2.column_name The "Pur" table OrderNo Custname City...
SQL LEFT JOIN & RIGHT JOIN
03:13
SQL LEFT JOIN & RIGHT JOIN
03:13 / 0 Comments
The SQL JOIN clause is used whenever we have to select data from 2 or more tables. To be able to use SQL JOIN clause to extract...
Subscribe to:
Posts (Atom)
