Join in sql server

Question

0.00/5 (No votes)

See more:

Hi I have 3 table.

Table1
StreamID int,
Stream Varchar,

Table2
PostStreamID int,
Stream Varchar,

Table3
UserID int
StreamID varchar(10),
PostStreamID varchar(10),
userName char(10)

Table1
-------------------------------------------
StreamID Stream
1 MCA
2 M.Tech
3 B.Tech

Table 2
-------------------------------------------
PostStreamID Stream
1 MA
2 Msc
3 Bsc

Table3
--------------------------------------
UserID StreamID PostStreamID userName
1 '1','2' '1','3' Jhon
2 '2','3' '2','3' Sachin

Now i want to join all the 3 table and fetch Stream and user name.How Can i do this? Please Help me.

Posted 14-Jan-11 21:48pm

c27bharti

Add a Solution

Comments

Sandeep Mewara 15-Jan-11 5:04am

1. I would suggest another table design to store values
2. The comma separated values stored in 3 - why are they like '1','2' and not '1,2' ?

c27bharti 15-Jan-11 8:21am

ya values are coming from my asp.net page where HR is posting job and he/she want a M.tech and MCA and also in +3 B.tech and BCA candidate. there for i have that option on my page to select multiple qulification and then post the job therefore i'm inserting id of selected value. and again i have show all the jobs and there i need to show what qulification need for which job there for i'm using join and try to show. It is my first project. What i should do. Help me. my english is not very good.

1 solution

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)

Wild-Programmer · Accepted Answer · 2011-01-15T01:25:00

The table structure is not normalized. You first need to normalize your tables as they dont even fall in 1st Normal form.

Then enter data correctly. Then only you will be able to set relationship between tables and fetch data easily with joins.

The table structure you have right now is messy and not at all fit for joining (un-relational) the way I see it.