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 CONCAT(cli.nome, ' ', cli.sobrenome) AS nome_completo, c.cor
AS cor_casa, b.nome AS bairro, car.modelo AS carro
FROM cliente cli
JOIN casa c
ON cli.id_cliente = c.id_casa
JOIN bairro b
ON cli.id_cliente = b.id_bairro
JOIN carro car
ON cli.id_cliente = car.id_carro;
SELECT CONCAT(cli.nome, ' ', cli.sobrenome) AS nome_completo, c.cor
AS cor_casa, b.nome AS bairro, car.modelo AS carro
FROM cliente cli
JOIN casa c
ON cli.id_cliente = c.id_casa
JOIN bairro b
ON cli.id_cliente = b.id_bairro
JOIN carro carro
ON cli.id_cliente = carro.id_carro;
SELECT
c.nome AS cliente,
c.endereco AS endereco,
c.bairro AS bairro,
c.carro AS carro
FROM clientes c;
SELECT CONCAT(cli.nome, ' ', cli.sobrenome) AS nome_completo, c.cor
AS cor_casa, b.nome AS bairro, car.modelo AS carro
FROM cliente cli
JOIN casa c
ON cli.id_cliente = c.id_casa
JOIN bairro b
ON cli.id_cliente = b.id_bairro
JOIN carro car
ON cli.id_cliente = car.id_carro;
Linkedin: https://www.linkedin.com/in/caique13rodrigues/
The text was updated successfully, but these errors were encountered: