for today I have a challenge is to make queries in SQL Server with the use of JOINS, if someone can help me it would be great the truth I do not know about the subject and I'm just depending on creating a database with some tables ..
for today I have a challenge is to make queries in SQL Server with the use of JOINS, if someone can help me it would be great the truth I do not know about the subject and I'm just depending on creating a database with some tables ..
In SQL Server you can make queries with JOIN in the following way:
INNER JOIN -- Que retorna data que tiene similitud entre ambas tablas
LEFT JOIN -- Que retorna data de la tabla de la izquierda y los datos que
-- tengan similitud de la tabla derecha
RIGHT JOIN -- Que retorna data de la tabla derecha y los datos que tengan
-- similitud de la tabla izquierda
FULL JOIN -- Retorna data de ambas tablas ya sea que haya similitud en la
-- izquierda o en la derecha