How to join 3 tables into one table in sqlserver 2005

Question

1.44/5 (2 votes)

See more:

SQL-Server-2005

Dear Experts !!

Am fresher to Sqlserver 2005 Database.

How to join 3 tables... to one table in sqlserver

so, here is my requirement :

I have 3 tables in my Database...as StudentCodes,Names,Marks

1)From First table[StudentCodes Table], i want to take StudentId
2)From second Table[Names Table], i want to take Student Name , StudentFathersName
3)From 3rd Table[Marks Table], I want to take Total Marks, Percentage

and Finally i want to make these 3 tables into one table.

Please can u suggest me, how to join these 3 tables to one Table.

Thanks a lot in Advance

Posted 27-May-12 0:03am

Ranjith Reddy CSE

Add a Solution

Comments

OriginalGriff 27-May-12 6:18am

From that information, we can't really help a lot.
You need to look at (or explain) your structure a bit better: for example, how do you know that the StudentId from StudentCodes ties to StudentName in the Names table? And the Marks Table?
And if you have a relationship already, why are you creating a new table? Doesn't that just duplicate information and reduce the maintainability of your data?
Use the "Improve question" widget to edit your question and provide better information.

3 solutions

Solution 2

Dear Ranjith,

1st u should have common id in all 3 tables, suppose Studentid.

SQL

Select a.studentid,b.name,b.fathername,c.marks,c.percent from 
StudentCodes a With (Nolock), Names b With (Nolock), Marks c With (Nolock)
where a.studentid=b.studentid and b.studentid=c.studentid and a.studentid=c.studentid

this is basic eg. hope it will help you.

Regards,
AP

Posted 27-May-12 0:21am

Arunprasath Natarajan

Updated 27-May-12 3:37am

v2

Comments

Mohamed Mitwalli 27-May-12 9:38am

5+

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2012-05-27T00:18:00

Solution 1

You need to read about SQL JOINS.

Here:
W3Schools: SQL Joins[^]
SQL Tutorial - SQL Joins[^]
CP: SQL Joins[^]
MSDN: Joins Fundamentals[^]

Posted 27-May-12 0:18am

Sandeep Mewara

Comments

Wendelius 27-May-12 7:20am

Good links

Sander Rossel 27-May-12 8:05am

W3Schools is my main reference for SQL queries.
MSDN is also a standard reference.
Nice links, all of them. My 5.

Mohamed Mitwalli 27-May-12 9:38am

5+

Wendelius · Accepted Answer · 2012-05-27T01:19:00

Solution 3

Most likely you don't mean that you want to join (create) a single table from those tables. Do you want to create a result set based on them. If that is the case, as Sandeep pointed out, you need a join.

So to select a single result set, your query could look something like:

SQL

SELECT sc.StudentId,
       n.StudentName,
       n.StudentFathersName,
       m.TotalMarks,
       m.Percentage
FROM   StudentCode sc 
       INNER JOIN Names n ON n.StudentId = sc.StudentId
       INNER JOIN Marks m ON m.StudentId = sc.StudentId

Posted 27-May-12 1:19am

Wendelius

Comments

Sander Rossel 27-May-12 8:05am

Nice answer, my 5.

devachrismohammed 14-Dec-13 4:32am

thanks a lot

Wendelius 27-May-12 9:21am

Thanks :)

Wendelius 14-Dec-13 14:24pm

You're welcome

Mohamed Mitwalli 27-May-12 9:38am

5+

Wendelius 1-Jun-12 0:37am

Thanks :)