I can join two or more table using something in common them:
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 :
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
this will help you