sql table interm c3 a9diaire

1SELECT CLI_NOM, TEL_NUMERO
2FROM T_CLIENT, T_TELEPHONE
3WHERE T_CLIENT.CLI_ID = T_TELEPHONE.CLI_ID

1CLI_NOM   TEL_NUMERO
2-------   --------------
3DUPONT    01-45-42-56-63
4DUPONT    01-44-28-52-52
5DUPONT    01-44-28-52-50
6BOUVIER   06-11-86-78-89
7DUBOIS    02-41-58-89-52
8DREYFUS   01-51-58-52-50
9DUHAMEL   01-54-11-43-21
10BOUVIER   06-55-41-42-95
11MARTIN    01-48-98-92-21
12MARTIN    01-44-22-56-21
13...

1SELECT CLI_NOM, TEL_NUMERO
2FROM   T_CLIENT C 
3       INNER JOIN T_TELEPHONE T
4             ON C.CLI_ID = T.CLI_ID
5WHERE  TYP_CODE = 'FAX'

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

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