MSQL数据库查询语句问题

如图所示，需要怎么写查询语句得到所有男性携带的物品

Select a. wp from tb1_zb a, tb2_pop b where a. name =b. name and b. sex = '男' 应该是这样

Select distinct a. wp from tb1_zb a, tb2_pop b where a. name =b. name and b. sex = '男'

需要加一个distinct，以防物品重复

select a.name,a.wp from tb1_zb
left join tb2_pop as b on b.name = a.name
where b.sex='男'

select wp

from tb1-zb

where name in

(select name
from tb2-pop

where sex='男')
或者
select wp

from tb1-zb a join tb2-pop b on a.name=b.name

where sex='男'