join »ç¿ëÇϱâ
ÀÛ¼ºÀÚ °ü¸®ÀÚ ÀÛ¼º½Ã°£ 2003-04-22 14:30:23
 

¿À³Ê ¿¬·É´ëº° Åë°èÄ¡:
select count(*) from member E, sgroup D where  E.dt_birthday between '1980%%%%' and '1984%%%%' and D.id_user=E.id_user;

ÃßõÀÎ ¿¬·É´ëº° Åë°èÄ¡
select count(auser) from
(select m.id_user as auser, substr(m.nm_reg1, 1, 2) as reg  from member m,
(select distinct id_propose as propose from member where id_propose not in ('.')) x
where x.propose=m.id_user)
where reg between 20 and 85


¸ñ·Ï | ÀÔ·Â | ¼öÁ¤ | ´äº¯ | »èÁ¦