DBMSSQL

JOINS in SQL

JOINS

Using the SELECT command you can retrieve data from several related tables also. But this is possible only if the tables are related with one other. Join operation is used to combine columns from multiple tables. In a join, the tables to be included in the query are specified in the FROM clause, separated by commas. The condition required for specifying the relationship between the tables is given in the WHERE clause.

The syntax for SELECT statement where we JOIN two tables in mentioned below:

SELECT <COLUMNS> FROM <TABLE1>, <TABLE2>,.... <TABLE N>;

Show More

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also
Close
Back to top button