Wednesday 14 August 2013

Joins in SQL Server

Join in SQL Sever

When we need to select data from more than one table then we can use joins in SQL Server. We can join two or more tables on the basis of common column between these tables.

Consider the following table which I am using in this example:-

Table 1:- Emp_Record

create table Emp_Record(eid int primary key, ename varchar(100), email varchar(100))



Figure 1

Table 2:-emp_sal

create table emp_sal(eid int foreign key references emp_record(eid), salary int, ispermanent varchar(100))



Figure 2
Types of Joins
Inner Join

When we need to select the common data from more than one table then we will use inner join. It will select only those data which will be common in these two tables.



8 comments:

  1. Web Designing and Advance UI Training in noida with HTML5, CSS3, Javascript, Jquery, Bootstrap, UI Testing and Live Project.
    http://www.techaltum.com/webdesigningtraininginnoida.html

    ReplyDelete
  2. great blog Here is STUCORNER the Best JAVA training institute in delhi you can visit their site:Stucorner

    ReplyDelete
  3. Because so many have dismissed blog commenting as an outreach strategy, there’s virtually no competition.Mobile Repairing Course in Delhi

    ReplyDelete
  4. Because so many have dismissed blog commenting as an outreach strategy, there’s virtually no competition.Computer Repairing Course in Delhi

    ReplyDelete
  5. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.

    Fitness equipment stores
    website designing company in west Delhi
    Top Hotels in mussoorie mall road

    ReplyDelete
  6. Hi, their colleagues, nice paragraph and nice arguments commented here, I am really enjoying by these.

    BCom Time Table

    BCom 1st year time table

    BCom 2nd year time table

    BCom 3rd year time table

    ReplyDelete