select a.userid ,b.url from tbluser a
right outer join tblurl b on a.userid=b.userid
select a.userid ,b.url from tbluser a
inner join tblurl b on a.userid=b.userid
select a.userid ,b.url from tbluser a
right outer join tblurl b on a.userid=b.userid
select a.userid ,b.url from tbluser a
inner join tblurl b on a.userid=b.userid