请问查出有多张会员卡的会员该怎么写
有会员卡和会员两张表，用member_no关联。怎么写，谢谢 sql
[解决办法]

引用:

引用:select *
from 会员卡,会员
where 会员卡.member_no=会员.member_no
如果我只需要有多个卡的会员名称怎么写呢

select 会员名称 FROM 会员表
where member_no in
(
select member_no from 会员卡
group by member_no having count(*) > 1
)