connecting two tables

Question

how to two tables in sql server?

barathi raja · Answer

SQL Join Types: There are different types of joins available in SQL: INNER JOIN: returns rows when there is a match in both tables. LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table. RIGHT JOIN: returns all rows from the right table, even if there are no matches in the left table. FULL JOIN: returns rows when there is a match in one of the tables. SELF JOIN: is used to join a table to itself as if the table were two tables, temporarily renaming at least one table in the SQL statement. CARTESIAN JOIN: returns the Cartesian product of the sets of records from the two or more joined tables.

Rajeesh Menoth · Answer

Hi, SQL joins are used to combine rows from two or more tables. Different Types Of Joins In Sql : INNER JOIN : Returns all rows when there is at least one match in BOTH tables LEFT JOIN : Return all rows from the left table, and the matched rows from the right table RIGHT JOIN : Return all rows from the right table, and the matched rows from the left table FULL JOIN : Return all rows when there is a match in ONE of the tables Reference : http://www.w3schools.com/sql/sql_join.asp

Vinay Singh · Answer

Hi You can use join to connect between two tables. have a look of the link "how to use join in sql"' http://www.tutorialspoint.com/sql/sql-using-joins.htm

connecting two tables

Answers (3)