¿äÁò¿¡ SQLÀ» ¹è¿ì´Â Àç¹Ì°¡µé·Á¼ ¹®Á¦¸¦ Ǫ´Âµ¥ µ¶ÇÐÀ¸·Î ÇÏ´Ùº¸´Ï±î ±Ã±ÝÇÑÁ¡ÀÌ ÀÖ³×¿ä ¤¾¤¾
ÇÁ·ÎÁ§Æ®¸íÀÌ 'A'ÀÎ ÇÁ·ÎÁ§Æ®¿¡ Âü¿©ÇÏ°í ÀÖ´Â »ç¿øÀÇ À̸§(name)°ú ºÎ¼¸í(dept)À» °Ë»öÇ϶ó
¶ó´Â ¹®Á¦¿¡¼
Á¦°¡ Ç®¾î³½ ´ä¾ÈÀº
select name, dept
from department, employee
where department.dept=employee.name and
assign project_name'=A';
Àε¥ Ȥ½Ã Ʋ¸°Á¡ÀÌ ÀÖÀ»±î¿ä?
Çؼ³ÀÌ ¾È³ª¿ÍÀճ׿ä ÀÌÃ¥ÀÌ