What is a join and explain types of joins

What is a join and explain types of joins.

Joins are used in queries to explain how different tables are related.
Joins also let you select data from a table depending upon data from another table.

Types of joins: INNER JOINs, OUTER JOINs, CROSS JOINs.
OUTER JOINs are further classified as LEFT OUTER JOINS, RIGHT OUTER JOINS and FULL OUTER JOINS
What is an extended stored procedure in SQL Server?
An extended stored procedure compiles as DLL and are created to expand capabilties of user defined stored procedure.......
What are triggers in SQL Server?
Triggers are special kind of event driven stored procedures. Executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table.......
What is a self join in SQL Server?
Two instances of the same table will be joined in the query........
Post your comment

Related Content

Follow us

▲