Query

[kewldudehere]

Hi All,

I have 2 tables with the following data.

Table1
Col1 Col2
a b
a c
a d
a e

Table 2
Col1 Col2
a 1
a 2
a 3

I have to write query that will get

a b 1
a c 2
a d 3
a e null

Thanks

[Dave44]

Give it an attempt first, i think you'll find this is pretty standard stuff. If you have trouble post your attempt here and we can point you in the right direction.

[Dilip1983]

Use outer join to achieve your output.

Let me know if you are not able to prepare the query.
It's not a hard query,You can try this out.

Thanks
Dilip