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 Harsh .
3,082,817 users have contributed to 147,418 threads and 483,473
In the past 24 hours, we have 6 new threads, 15 new posts, and 97 new users.
In last week, the most popular thread is 'asp:ModalPopupExtender not working with ajax post webmethod in ASP.NET'.

Upcoming events

View all

.NET Conference 2025
Overview of Web API in Power Pages - Microsoft Business Application: Ep.29
Deep Dive into Flutter, NoSQL, and Power Fx