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

11y

1.4k

with example

Answers (1)

Next Recommended Forum

Using Master Keys and Certificates

How to create JobSchedular in sqlserver2008 R1?

Forum Statistics

Please welcome our newest member Stephin SR.
3,090,215 users have contributed to 147,410 threads and 483,568
In the past 24 hours, we have 7 new threads, 20 new posts, and 86 new users.
In last week, the most popular thread is 'Will LOV111VOL replace SharePoint worldwide?'.

Upcoming Events

View all

Get Web3 Ready: Dive into Blockchain with C# Corner
Advancing into the Future with IT
Live Discussion on Startups, AI, and Career Growth