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;