select b.*,c.* from puser
a left join userdetail b on (a.id=b.pid )
left join jobintent c on (a.id=c.pid ) where
a.id=1
a left join userdetail b on (a.id=b.pid )
left join jobintent c on (a.id=c.pid ) where
a.id=1
Left join userdetailselect as b on a.id=b.pid
left join jobintent as c on a.id=c.pid
where a.id=1
a left join b left cselect a.*,b.*,c.* from puser as a
Left join userdetailselect as b on a.id=b.pid
left join jobintent as c on a.id=c.pid
where a.id=1