我有两张表,一张是用户表,另一张是专业表。用户表中的字段:用户in、用户名、专业表中的userLocation字段:用户in、userSpecialtyselect * from ( select * from user where userLocation = 'value') u inner join specialty s on u.userid = s.userid;或
select * from user u inner join specialty s on u.userid = s.userid where u