What is the method for using 3rd table [Resolved]

Posted by Oswaldlily under Sql Server on 3/6/2014 | Points: 10 | Views : 1979 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

i have written query with 2 tables used..(no of rows 50)

now i need to use only one column from 3rd table ..

for this have to use join??

(Note: No of rows should be same as 50..just one column have to included from 3rd table)

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bandi on: 3/6/2014 [Member] [MVP] Platinum | Points: 50

0	Yes you have to do join with third table.... Your query also looking good.. As per ANSI standard you can make use of INNER JOIN as follows: Select t1.Number,t1.Price,t1.code,t2.pkg,t3.data from Table1 t1 INNER JOIN Table t2 ON t1.code=t2.code INNER JOIN Table3 t3 ON t3.code=t2.code Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

Yes you have to do join with third table.... Your query also looking good..

As per ANSI standard you can make use of INNER JOIN as follows:

Select t1.Number,t1.Price,t1.code,t2.pkg,t3.data 
from Table1 t1
INNER JOIN Table t2 ON t1.code=t2.code
INNER JOIN Table3 t3 ON t3.code=t2.code

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Oswaldlily on: 3/6/2014 [Member] Starter | Points: 25

0	Table1 Number Price code Ao 100 a B0 200 b C0 300 c Table2 pkg code abc a def b ghi c Table3 Number price code data A1 50 a xyz A2 50 a xyz B1 100 b pqr B2 100 b pqr C1 150 c abc C2 150 c abc expected output Number Price code pkg data A0 100 a abc xyz B0 200 b def pqr C0 300 c ghi abc Mine is cming as(wrong) Number Price code pkg data A0 100 a abc xyz A0 100 a abc xyz B0 200 b def pqr B0 200 b def pqr C0 300 c ghi abc C0 300 c ghi abc My query Select t1.Number,t1.Price,t1.code,t2.pkg,t3.data from Table1 t1,Table t2,Table3 t3 where t1.code=t2.code and t3.code=t2.code Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

Table1
Number Price code

Ao 100 a
B0 200 b
C0 300 c

Table2
pkg code

abc a
def b
ghi c

Table3
Number price code data

A1 50 a xyz
A2 50 a xyz
B1 100 b pqr
B2 100 b pqr
C1 150 c abc
C2 150 c abc

expected output
Number Price code pkg data
A0 100 a abc xyz
B0 200 b def pqr
C0 300 c ghi abc

Mine is cming as(wrong)

Number Price code pkg data
A0 100 a abc xyz
A0 100 a abc xyz
B0 200 b def pqr
B0 200 b def pqr
C0 300 c ghi abc
C0 300 c ghi abc

My query

Select t1.Number,t1.Price,t1.code,t2.pkg,t3.data from Table1 t1,Table t2,Table3 t3
where
t1.code=t2.code
and
t3.code=t2.code

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts