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



361

except raw sql,thanks