Right Join

[zy_abc]

Select  x,y,ID   from a  right join  b on a.rt=b.rt

I want to retreive the description of the ID from other table. How to do it? Please help me out.

 

[a_jam_sandwich]

SELECT Table1.ID, Table1.Name, Table2.Description FROM Table1 RIGHT JOIN Table2 ON Table1.ID = Table2.ID

Andy

 

[zy_abc]

a_jam_sandwich thanks for replying. The description of the ID comes from another table which Is "Table 3"

 

[a_jam_sandwich]

How many tables ???

 

[zy_abc]

Table 1

X       ID
2       I001

Table 2

Y
1
2
3

Table 3
ID          Name
I001      QER
I002      TYU

Select  Y,ID   from Table1  right join  Table2 on Table1.x=Table2.Y

Instead of ID i would like to get the Name. How to go about for that a_jam_sandwich.

 

[a_jam_sandwich]

I cant quite see how table 3 relates to table1 or table2

Table1 right join to Table2 using Table1.x & Table2.y

Table3 ??? Relate to (Table1 or Table2)

Please explain abit more

Andy

 

[zy_abc]

Table 3 relates to Table 1.

When i execute Select  Y,ID   from Table1  right join  Table2 on Table1.x=Table2.Y

I get the output as 
Y            ID
1
2           I001
3

I want to get the Name of ID from Table 3

The output should be somewhat like this
Y               ID            Name
1
2             I001             QER
3

 

[a_jam_sandwich]

Try something like

SELECT Table1.ID, Table1.X, Table2.Y, Table3.Name
FROM (Table1 LEFT JOIN Table2 ON Table1.ID = Table2.ID) RIGHT JOIN Table3 ON Table1.ID = Table3.ID

 

[zy_abc]

Thanks for the solution. It works perfectly now