sql

[raj code]

Table 1 ------- col1 col2 ------------ 1 1 1 2 Table 2 --------- col1 col3 ----------- 1 a 1 b 1 c 1 d Please help me out in building a query which gives the following output: col1 col2 col3 ----------------- 1 1 a 1 2 b 1 NULL c 1 NULL d Thank u

[Colin Angus Mackay]

SELECT T2.col1, T1.Col2, T2.Col3
FROM T1
RIGHT OUTER JOIN T2 ON T1.Col1 = T2.Col1

---

Upcoming events: * Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website

[raj code]

I appreciate ur help. But sorry Colin Angus Mackay it doesnt give the format i wanted,I already tried out all the joins.

[Ron Savage]

Hi Raj,

select
t2.col1,
t1.col2,
t2.col3
from
tab2 t2

LEFT OUTER JOIN tab1 t1
ON ( t1.col2 = ascii(t2.col3) - 96 )

Results:
col1 col2 col3

---

1 1 a
1 2 b
1 NULL c
1 NULL d

Pretty silly way to join data though, I hope it was part of a "puzzle" question and not a serious solution. :-)

Ron