join : to join one or more than one table which are ain relationship ex: Employee and Department data : Hari and Ram belongs to HR Sam belongs to IT then you must have 2 tables for normalization Employee table ----------- EMPID Name DeptID 1 Hari 1 2 Sam 2 3 Ram 1 Department table --------------- Deptid DeptName 1 HR 2 IT Inner join : This join returns rows when there is at least one match in both the tables. Select * from employee e Inner join Department d on e.Deptid = d.deptid Outer join : LEft outer join Right outer join and cross join for more details check this http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/

Answer

What is joins & its type

vivek upadhyay

10y

965

with example

Answers (1)

Next Recommended Forum

Using Master Keys and Certificates

How to create JobSchedular in sqlserver2008 R1?

View all

Member of the month

Rinki

Chennai (India)

6.1k

14.2k

Speaker of the month

Shivam Payasi

C#, .NET

Chitrakoot (India)

22.3k

20.2k

Upcoming events

View all

Bhubaneswar Chapter
Building Websites with Microsoft Power Pages: Exploring WebPage, WebTemplate, and Page Templates - Microsoft Business Application Ep. 25

Suggested for you

View all

Mahesh Chand

Manish Tewatia

John Miller

Priyanshu Agnihotri

Alistair Cook

Forum Statistics

Please welcome our newest member User Madhu.
2,380,752 users have contributed to 122,527 threads and 389,004
In the past 24 hours, we have 0 new threads, 0 new posts, and 0 new users.
In last week, the most popular thread is 'why a good project structure is important'.