As a .NET Developer most of the common tasks you do are database related operations, like INSERT, SELECT UPDATE and DELETE. These tasks are often collectively referred to as CRUD operations. The problem comes when writing a complex query directly or in a Stored Procedure that retrieves expected data from more than one table of your Normalized database, in other words you are working on “Joining the Tables” to pull the data. Read Full Article Here
Agenda
- Creating two sample tables for Join
- Insert data into sample Join tables
- Inner Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Cross Join