Mysql多表关联查询

SELECT * FROM database.tablename1 AS a,database.tablename2 AS b where a.id=b.userid;