Get different columns from different tables

Is there any way to build query like select t1.id,t1.name,t2.mobile from t1 inner join t2 on t1.id=t2.userid thanks for help



354

except raw sql,thanks