+ 2

why we use joins in sql?

because to view the result from 2 tables

4th Mar 2017, 4:48 PM
GADE. NAVEEN
GADE. NAVEEN - avatar
6 ответов
+ 3
join is basically used to join two different tables present in same or different databases ....
5th Mar 2017, 4:48 AM
Nikhil Kumar
Nikhil Kumar - avatar
+ 2
joins are used in sql to combine data from two or more tables/views within a database. Per example, if you have a table that contains username, phone and adress. And you have a second table that contains username and salary, now with joins you can create a view that will show you username, phone, adress, salary
5th Mar 2017, 2:54 PM
Joseph Castel
0
The SQL Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each. Here, it is noticeable that the join is performed in the WHERE clause. A sql join clause combines columns from one or more tables in a relational database. It creates a set that can be saved as a table or used as it is. A join is a means for combining columns from one (self-table) or more tables by using values common to each.
6th Mar 2017, 5:59 AM
Akwin Lopez
Akwin Lopez - avatar
0
Join is used to return combined data from multiple tables.
16th Mar 2017, 7:17 PM
Dzung Le
Dzung Le - avatar
0
SQL - Using Joins. The SQL Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each. ... Here, it is noticeable that the join is performed in the WHERE clause.
27th Apr 2017, 8:22 AM
MM Suhayb
MM Suhayb - avatar
0
to combine two or more than one table data in one result also to make it easy when you are searching for data that exists in more than one location or tables
13th May 2017, 2:44 AM
AlkhidierAbdalla Bakhiet idriss
AlkhidierAbdalla Bakhiet idriss - avatar