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'
SELECT CLI_NOM, TEL_NUMERO FROM T_CLIENT C, T_TELEPHONE T WHERE C.CLI_ID = T.CLI_ID
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 ...
SELECT CLI_NOM, TEL_NUMERO FROM T_CLIENT, T_TELEPHONE WHERE T_CLIENT.CLI_ID = T_TELEPHONE.CLI_ID
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'