mysql子查询返回多于1行_查找子查询中的差异结果会在mysql错误中返回多于1行

我有一个名为tbl_populations的表，其中包含以下字段：

pk_populationid,residence,value,aspect,gender,fk_tbl_states_stateid我试图计算两个方面的行的差异

例如，

SELECT fk_tbl_states_stateid, value - (

SELECT value

FROM tbl_populations

WHERE fk_tbl_states_stateid = '16'

AND fk_tbl_districts_districtid = '0'

AND residence = '0'

AND gender = '0'

AND aspect = '2' ) AS difference

FROM tbl_populations

WHERE fk_tbl_states_stateid = '16'

AND fk_tbl_districts_districtid = '0'

AND residence = '0'

AND gender = '0'

AND aspect = '1'它工作正常，因为它返回一行

为了获取多个我想检索所有性别值的数据，我已经从条件中删除了性别。

SELECT fk_tbl_states_stateid,gender, value - (

SELECT value

FROM tbl_populations

WHERE fk_tbl_states_stateid = '16'

AND fk_tbl_districts_districtid = '0'

AND residence = '0'

AND aspect = '2' ) AS difference

FROM tbl_populations

WHERE fk_tbl_states_stateid = '16'

AND fk_tbl_districts_districtid = '0'

AND residence = '0'

AND aspect = '1'我得到Subquery returns more than 1 row错误。

我怎样才能得到所有的结果？