select a.*,b.* from table联系人 as a join table公司名 as b on a.account_id=b.account_id

------解决方案--------------------

SQL code

select * from [table联系人] a inner join [table公司名] b on a.account_id = b.account_id