You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT
c.nome AS 'Nome do Cliente',
c.sobrenome AS 'Sobrenome do Cliente',
c.data_nascimento AS 'Data de Nascimento do Cliente',
cas.cor AS 'Cor da Casa',
b.nome AS 'Bairro',
car.modelo AS 'Modelo do Carro'
FROM
cliente c
LEFT JOIN
casa cas ON c.id_cliente = cas.fk_cliente
LEFT JOIN
bairro b ON b.id_bairro = cas.fk_bairro
LEFT JOIN
carro car ON car.fk_cliente = c.id_cliente;
The text was updated successfully, but these errors were encountered:
SELECT
c.nome AS 'Nome do Cliente',
c.sobrenome AS 'Sobrenome do Cliente',
c.data_nascimento AS 'Data de Nascimento do Cliente',
cas.cor AS 'Cor da Casa',
b.nome AS 'Bairro',
car.modelo AS 'Modelo do Carro'
FROM
cliente c
LEFT JOIN
casa cas ON c.id_cliente = cas.fk_cliente
LEFT JOIN
bairro b ON b.id_bairro = cas.fk_bairro
LEFT JOIN
carro car ON car.fk_cliente = c.id_cliente;
The text was updated successfully, but these errors were encountered: