청강컴정/09DataBase중간고사
가입한 카페 목록
luckey
2009. 4. 25. 12:08
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
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