表aa,存放 id和name,表bb存放id和salary,如何根据name查到salary?
select bb.salary from bb inner join aa on aa.id = bb.id where aa.name = 'cr';
表aa,存放 id和name,表bb存放id和salary,如何根据name查到salary?
select bb.salary from bb inner join aa on aa.id = bb.id where aa.name = 'cr';