가입한 카페 목록

create proc myCafe(@mID varchar(20))
as
begin
 select fk_cafe as cNum, cf.name as cName
 from member_join as mj
 inner join cafe as cf
 on mj.fk_cafe = cf.sn
 inner join member as mb
 on mj.fk_member = mb.sn
 where id = @mID
end