field values from multiple tables

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

hi to all!

can some one tell me that whats the problem here my data is not displaying in the query below it shows the name of fields only
i want to display the field values

SQL

select sec_modules.modname_vc, sec_roles.rolename_vc, sec_functions.functionname_vc

from sec_umrf_details

left join sec_mrf_details on sec_mrf_details.mrfno_nu = sec_umrf_details.mrfno_nu
left join sec_modules on sec_modules.modid_int = sec_mrf_details.modid_int
left join sec_roles on sec_roles.roleid_int = sec_mrf_details.roleid_int
left join sec_functions on sec_functions.fnid_int = sec_mrf_details.fnid_int

where sec_mrf_details.mrfno_nu = 1

Posted 20-Aug-11 18:59pm

kami124

Updated 20-Aug-11 19:11pm

thatraja

v2

Add a Solution

Comments

Abhinav S 21-Aug-11 1:06am

Are you sure there is a result available for all these joins?

kami124 21-Aug-11 1:10am

yes i chect it twice there is result for sec_mrf_details.mrfno_nu = 1
and all other also

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)

Christian Graus · Answer 1 · 2011-08-20T20:41:00

Solution 1

I would try an inner join to see if you get the values where the join matches, and I'd remove the first table, as you don't actually grab any data from there. The data would have to match the value in the mrf table, so just grab it from there. Once you have a simpler query that works, you can start to make it more complex.

Posted 20-Aug-11 20:41pm

Christian Graus

Comments

RaisKazi 21-Aug-11 3:34am

Agree with Christian. 5.
kami124 - You should start with simple plain select Query first. See the result. And then start applying Joins one by one.