Hai Friends I Have A Question On Database Query

Question

1.00/5 (2 votes)

See more:

SQL-Server-2008R2

i have three tables
like

table

tlid mbno name gender 
tl1   123   yes      m

table1

id   tlid	 rfid
1     tl1	 12	
2     tl1       
3     tl1

table2

rfid   type  abc  xyz tlid
12     one    a..   x..   tl1

i want to show the details like

how to write a query for this can you please tell me depend on mbno

tlid  id  name gender type abc xyz
tl1    1    yes      m     one  a..  x..
tl1    2    yes      m 
tl1    3    yes      m

i don't wanna show like this

tlid  id  name gender type abc xyz
tl1    1    yes      m     one  a..  x..
tl1    1    yes      m
tl1    2    yes      m 
tl1    3    yes      m

Posted 9-Apr-15 21:06pm

Parazival

Updated 9-Apr-15 21:20pm

Tomas Takac

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)

OriginalGriff · Answer 1 · 2015-04-09T21:44:00

Solution 1

Try:

SQL

SELECT a.tlid, a.id, b.name, b.gender, c.type, c.abc, c.xyz
FROM table1 a
JOIN [table] b ON a.tlid = b.tlid
LEFT JOIN table2 c ON a.rfid = c.rfid

Posted 9-Apr-15 21:44pm

OriginalGriff

Updated 9-Apr-15 22:39pm

v2

Comments

Parazival 10-Apr-15 4:14am

sorry it will show only one record

tlid id name gender type abc xyz
tl1 1 yes m one a.. x..

thanks

OriginalGriff 10-Apr-15 4:40am

Didn't notice your null values - answer updated.

Member 10197359 · Answer 2 · 2015-04-10T00:40:00

Solution 2

SELECT table.tlid ,
table1.id ,
table.NAME ,
table.gender ,
table2.TYPE ,
table2.abc ,
table2.xyz
FROM table
LEFT JOIN table1 ON ( table.tlid = table1.tlid )
LEFT JOIN table2 ON ( table2.rfid = table1.rfid
AND table.tlid = table2.tlid
)

Posted 10-Apr-15 0:40am

Member 10197359

Comments

Parazival 10-Apr-15 23:08pm

nice one but
same out put
tlid id name gender type abc xyz
tl1 1 yes m one a.. x..
tl1 1 yes m// i don't want this record
tl1 2 yes m
tl1 3 yes m

thankssss