Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL What is a "join"?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


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


What is a "join"?


Advertisement
View Answers

November 18, 2010 at 11:50 AM


Hi,

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:
Advertisements
 

 

 

DMCA.com