How to joins table in sql??

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

Also good know:
JOIN = horizontal
APPEND = vertical

Answer 6

Anban mb

Answer 7

Select * from table1name , table2name;