hemant kumar
What is a "join"?
1 Answer(s)      5 years and a month ago
Posted in : SQL

What is a "join"?

View Answers

November 18, 2010 at 11:50 AM


Here is the answer,

The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables.

Tables in a database are often related to each other with keys.A join is used to combine rows from multiple tables. A join is performed whenever two or more tables is listed in the FROM clause of an SQL statement.

For example,

SELECT suppliers.supplierid, suppliers.suppliername, orders.order_date FROM suppliers, orders WHERE suppliers.supplierid = orders.supplierid;

Related Tutorials/Questions & Answers: