Mute
Cleyton Sabino
JUNÇÕES (JOINS) INNER JOIN ```sql SELECT p.nome, c.nome_categoria FROM produtos p INNER JOIN categorias c ON p.categoria_id = c.id; ``` LEFT JOIN ```sql SELECT c.nome, p.data_pedido FROM clientes c LEFT JOIN pedidos p ON c.id = p.cliente_id; ``` RIGHT JOIN ```sql SELECT p.descricao, f.nome FROM produtos p RIGHT JOIN fornecedores f ON p.fornecedor_id = f.id; ``` FULL OUTER JOIN (MySQL não tem, usa UNION) ```sql SELECT * FROM tabela1 LEFT JOIN tabela2 ON condição UNION SELECT * FROM tabela
Follow
52
1
21
kwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwai