writing sql server querry

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

hi to all!

here i find difficult to write a querry

can u help me to write that querry

i have three tables T1, T2, T3

T1 has fields
u/id and mrf/id

T2 has fields
mrf/id and m/id

T3 has fields
m/id and m/name

given i have u/id and i have to get m/name

Posted 8-Aug-11 23:01pm

kami124

Updated 8-Aug-11 23:02pm

v2

Add a Solution

2 solutions

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)

Abhinav S · Accepted Answer · 2011-08-08T23:34:00

Solution 2

SQL

select mid
from T3
inner join T2 on T3.mid = T2.mid
inner join T1 on T1.mrfid = T2.mrfid and T1.uid = @uid

Posted 8-Aug-11 23:34pm

Abhinav S

Comments

kami124 9-Aug-11 6:13am

ok i make it like this
but the result is displaying name of field
but i need the values of field
i make my code like this

select modname_vc
from sec_modules
inner join sec_mrf_details on sec_modules.modid_int=sec_mrf_details.modid_int
inner join sec_umrf_details on sec_mrf_details.mrfno_nu=sec_umrf_details.mrfno_nu
where sec_umrf_details.userid_vc='ali'

arathi_suresh · Accepted Answer · 2011-08-08T23:05:00

Solution 1

Here it is

select mname from T3 where mid in(select mid from T2 where mrfid in(select mrfid from T1 where uid=@uid))

Posted 8-Aug-11 23:05pm

arathi_suresh

Comments

kami124 9-Aug-11 5:33am

ya its showing only the field name
i want field values

_Zorro_ 9-Aug-11 5:40am

Hi, you should take a look at Abhinav S query, it's way more performant than using SELECT IN, if you don't believe me take a look at your execution plan, the difference should be obvious.