why we use joins in sql?

Question

because to view the result from 2 tables

Answer 1

join is basically used to join two different tables present in same or different databases ....

Answer 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

Answer 3

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.

Answer 4

Join is used to return combined data from multiple tables.

Answer 5

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.

Answer 6

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