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 vote144 views1 answer
Convert .mdf to .bak
SQL
0 vote147 views1 answer
How many rows affected in sqllite
SQL
1 vote129 views1 answer
Oracle lock user
SQL
0 vote176 views1 answer
Get initials name in sql
SQL
18 votes157 views6 answers
Laravel form validation
SQL
0 vote163 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote151 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote142 views1 answer
Mysql subdate
SQL
8 votes153 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote150 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL