+19

How to joins table in sql??

3/13/2019 1:23:11 AM

Kaju Kishmish❤

7 Answers

New Answer

+4

I can join two or more table using something in common them: Example: TABLE1 TABLE2 1- Both they have de same column "IDCLIENT", so you can do: 2 - You have to set some nickname to both tables in this case I set "TB1 = TABLE1" and "TB2 = TABLE2". SELECT IDCLIENT (any columns you want) FROM TABLE1 TB1 INNER JOIN TABLE2 TB2 ON (TB1.IDCLIENT = TB2.IDCLIENT) There are lot of ways to join tables : https://www.dofactory.com/sql/join

+14

Thank... Ur answer absolutely right😎😎👍👍👍tanay😊

+14

Tysm.... Ramon domingues Awesome answer n ur link.. 👍

+5

Thanks for this link, #Ramon Dominguez, it looks like very good !

+2

Hi... 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. Lets join two tables SQL> SELECT ID, NAME, AGE, AMOUNT FROM CUSTOMERS, ORDERS WHERE CUSTOMERS.ID = ORDERS.CUSTOMER_ID; We can join tables in sql using the Join keyword https://www.sololearn.com/learn/SQL/1865/?ref=app this will help you

+1

Also good know: JOIN = horizontal APPEND = vertical

0

Anban mb