Posts by Erlon Ferreira de Souza • 1 point
1 post
-
0
votes1
answer201
viewsA: Show NULL SQL values
Hello, You can use left Join: SELECT * FROM [emp] AS [e] LEFT JOIN [dep] AS [d] ON e.ndep = d.ndep order by [d].nome, [e].nome;
1 post
0
votes1
answer201
viewsHello, You can use left Join: SELECT * FROM [emp] AS [e] LEFT JOIN [dep] AS [d] ON e.ndep = d.ndep order by [d].nome, [e].nome;