There are following joins in Sql Server:
1). Inner joins: It returns all rows when there is at least one match in both tables
2). Non-Equi joins: It uses comparison operator instead of the equal sign like >, <, >=, <= along with conditions.
3). Outer joins
a). Left outer joins: It return all rows from the left table,and the matched rows from the right table
b). Right outer joins: It return all rows from the right table,and the matched rows from the left table
c). Full outer joins: It displays all the matching and non matching rows of both the tables.
4). Self joins: Joining the table itself called self join.It happens in the same table.
5). Cross joins: A cross join that produces Cartesian product of the tables.
Asked In: Many Interviews |