SQL Server Connection Query jion

Inner join On/join on inner join unmatched row does not return data

Left join on outer join returns all matching rows from two tables and unmatched rows in the left table of the Join keyword, with null padding for unmatched rows

The right join on the outer join returns all matching rows from two tables and rows that do not match in the table to the right of the JOIN keyword, with null padding for unmatched rows

Full join on fully connected returns all matching rows in two tables and unmatched rows with null padding for unmatched rows

The cross join intersection returns the Cartesian product mathematics in which all rows in the two tables are connected: Assuming set a={a,b}, set b={0,1,2}, the Cartesian product of two sets is {(a,0), (a,1), (a,2), (b,0), (b,1), (b,2)}

A self-connected query requires a table alias select S. Course number, C. Instructor from course Information S, course information C where S. Course number =c.

Self-connect equivalent to cross-connect

SQL Server Connection Query jion