MYSQL查询语句求教

Question

表A
uid
username

表B
id
uid
mobile

问题：如何在表B中根据username查询相关数据？

Answer 1

select * from tableB inner join tableA on tableB.username = tableA.username