Hi
use this query,

Select concat(T1.fname, T2.lname) as name from tab1 as T1
join tab2 T2 on T1.id=T2.id;