Sql table intermédiaire

SELECT CLI_NOM, TEL_NUMERO
FROM T_CLIENT, T_TELEPHONE
WHERE T_CLIENT.CLI_ID = T_TELEPHONE.CLI_ID

Source: sqlpro.developpez.com

Sql table intermédiaire

CLI_NOM   TEL_NUMERO
-------   --------------
DUPONT    01-45-42-56-63
DUPONT    01-44-28-52-52
DUPONT    01-44-28-52-50
BOUVIER   06-11-86-78-89
DUBOIS    02-41-58-89-52
DREYFUS   01-51-58-52-50
DUHAMEL   01-54-11-43-21
BOUVIER   06-55-41-42-95
MARTIN    01-48-98-92-21
MARTIN    01-44-22-56-21
...

Source: sqlpro.developpez.com

Sql table intermédiaire

SELECT CLI_NOM, TEL_NUMERO
FROM   T_CLIENT C 
       INNER JOIN T_TELEPHONE T
             ON C.CLI_ID = T.CLI_ID
WHERE  TYP_CODE = 'FAX'

Source: sqlpro.developpez.com

Sql table intermédiaire

SELECT C.CLI_ID, C.CLI_NOM, T.TEL_NUMERO
FROM T_CLIENT C, T_TELEPHONE T
WHERE C.CLI_ID = T.CLI_ID
  AND T.TYP_CODE = 'FAX'

Source: sqlpro.developpez.com

Sql table intermédiaire

SELECT CLI_NOM, TEL_NUMERO
FROM T_CLIENT C, T_TELEPHONE T
WHERE C.CLI_ID = T.CLI_ID

Source: sqlpro.developpez.com

Similar codes

0 vote173 views2 answers
Oracle create chain rule
SQL
2 votes161 views1 answer
Check isolation level in mysql
SQL
1 vote177 views1 answer
T-sql disable system versioning
SQL
6 votes175 views2 answers
Mysql execute file
SQL
19 votes197 views6 answers
Create table sqlite
SQL
0 vote180 views1 answer
Oracle gather table statistics
SQL
12 votes176 views4 answers
How to take database dump in postgresql
SQL
0 vote177 views1 answer
Using GROUP BY in MySQL Join Table
SQL
31 votes182 views4 answers
How to get duplicate records with multiple field in sql
SQL
2 votes200 views1 answer
Capitalize 1st letter in sql server
SQL