getting data from sql server

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

here in my code
sec_umfr_details is table 1 having userid_vc,mrfno_nu
sec_mrf_details is table 2 having mrfno_nu and fnid_int

i have userid_vc and mrfno_nu and
i have to display fnid

Posted 28-Jul-11 0:35am

kami124

Updated 28-Jul-11 0:38am

v2

Add a Solution

3 solutions

Solution 1

Have a look at the last question you posted

querry to get information about user[^]

The examples there should show you how to create a JOIN on your tables so you can retrieve the data you want.

Try and create an SQL statement to do this, if you have a problem then post back what you don't understand

This is really quite simple, you can figure it out yourself if you look at the previous question :)

Posted 28-Jul-11 0:53am

Dylan Morley

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)

Manas Bhardwaj · Accepted Answer · 2011-07-28T00:54:00

Solution 2

SQL

SELECT 
	sec_mrf_details.fnid_int
FROM sec_umfr_details INNER JOIN sec_mrf_details
	sec_umfr_details.mrfno_nu = sec_mrf_details.mrfno_nu
WHERE
	sec_umfr_details.mrfno_nu = 'whatever'
	AND sec_mrf_details.userid_vc  = 'again whatever'

you should consider looking JOINS[^]

Posted 28-Jul-11 0:54am

Manas Bhardwaj

v2

Comments

kami124 28-Jul-11 7:02am

same thin i have done but still

select sec_mrf_details.fnid_int
from sec_umrf_details
inner join
sec_mrf_details
on
sec_umrf_details.mrfno_nu = sec_mrf_details.mrfno_nu
where
sec_umrf_details.userid_vc='i-jadoon'
and
sec_umrf_details.mrfno_nu=1

Manas Bhardwaj 28-Jul-11 7:08am

that means you have not data matching this condition.

Abhinav S · Accepted Answer · 2011-07-28T00:58:00

Solution 3

Join the two tables on mrfno_nu and select fnid from the query.

Posted 28-Jul-11 0:58am

Abhinav S