How to joins table in sql??

3/13/2019 1:23:11 AM

Kaju Kishmish❤

8 Answers

New Answer


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


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


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


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


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


Also good know: JOIN = horizontal APPEND = vertical


Anban mb


Select * from table1name , table2name;