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
cl.nome AS Cliente,
casa.cor AS CorCasa,
bairro.nome AS Bairro,
ca.modelo AS Carro
FROM
cliente cl
JOIN
casa casa ON cl.id_cliente = casa.fk_cliente
JOIN
bairro ON casa.fk_bairro = bairro.id_bairro
JOIN
carro ca ON cl.id_cliente = ca.fk_cliente;
Cliente CorCasa Bairro Carro
Fernando Vermelho Mooca Fiat
Bruno Roxo Ipiranga Mercedes
Fernanda Azul Vila Hamburguesa Honda
Arthur Rosa Lapa Toyota
Fernando Vermelho Mooca Lada
The text was updated successfully, but these errors were encountered:
127.0.0.1/westwing_brasil_teste/ http://localhost/phpmyadmin/index.php?route=/table/sql&db=westwing_brasil_teste&table=cl
localhost _ 127.0.0.1 _ westwing_brasil_teste _ phpMyAdmin 5.2.1.pdf
SELECT
cl.nome AS Cliente,
casa.cor AS CorCasa,
bairro.nome AS Bairro,
ca.modelo AS Carro
FROM
cliente cl
JOIN
casa casa ON cl.id_cliente = casa.fk_cliente
JOIN
bairro ON casa.fk_bairro = bairro.id_bairro
JOIN
carro ca ON cl.id_cliente = ca.fk_cliente;
Cliente CorCasa Bairro Carro
Fernando Vermelho Mooca Fiat
Bruno Roxo Ipiranga Mercedes
Fernanda Azul Vila Hamburguesa Honda
Arthur Rosa Lapa Toyota
Fernando Vermelho Mooca Lada
The text was updated successfully, but these errors were encountered: