Need help with sql query

Question

Table 1
id - name
1  - ric
2  - joe
3  - harry
4  - james

Table 2 
sno - Tbl_1_Id - notes
1   - 1        - abcdef
2   - 4        - xyzzz

I want the result to be

id - name - notes
1  - ric  - abcdef
2  - joe  - 
3  - harry- 
4  - james- xyzzz

Akhil · Accepted Answer · 2011-06-08 22:06:48Z

2

SELECT   t1.id, t1.name, t2.notes
FROM     Table1 t1
         LEFT OUTER JOIN Table2 t2 ON t1.id = t2.Tbl_1_Id

answered Jun 8, 2011 at 22:06

Akhil

7,6201 gold badge26 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Johan · Accepted Answer · 2011-06-08 22:07:31Z

2

Use a left join.

SELECT t1.id, t1.name, t2.notes FROM 
table1 as t1 
LEFT JOIN table2 as t2 ON (t1.id = t2.tbl_1_id)

answered Jun 8, 2011 at 22:07

Johan

77.4k28 gold badges204 silver badges346 bronze badges