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.3k

with example

Answers (1)

Next Recommended Forum

Using Master Keys and Certificates

How to create JobSchedular in sqlserver2008 R1?

Leaderboard

View all

George

Mohammad Hasan Hosseini

-160

Sangeetha S

-6

View all

Yesterday's leader

George

USA

4.2m

33.9k

Member of the month

Shafaet Hossain

C#, .NET, ASP.NET, Blazor

Dhaka (Bangladesh)

707

9.6k

1.3k

Speaker of the month

Shubhankar Banerjee

Blockchain, Solidity, Polygon, C#, NodeJS, HTML, C Language, C++, JavaScript, CSS, ReactJS, MySQL

Kanpur (India)

155

117.6k

11.8k

500

Upcoming events

View all

What is the Actors: Dapr in Action - Ep. 11
.NET Conference 2025

Suggested for you

View all

Dharati Patel

Ayush Gupta

Rajiv Singh

Ashutosh Singh

Dinesh Gabhane

Forum Statistics

Please welcome our newest member Thirupathi P.
3,078,279 users have contributed to 147,418 threads and 483,404
In the past 24 hours, we have 6 new threads, 27 new posts, and 55 new users.
In last week, the most popular thread is 'ItemId is not able to save into the tblQuantities'.