join help

[qvqfqlik]

Iam trying to join and get data in such a way that

when there is a match for a number from table1 in table2 , I would need to display the fname and lname from table1

and when there is no match for a number, I simply need to show the number from table2

I have attached some sample data.

Please help me with this.

[aarkay29]

PFA

[qvqfqlik]

Thank you very much