<![CDATA[
<P><FONT size=2><STRONG><SPAN style="FONT-SIZE: 12pt">통계 분석 연구회 (</SPAN><FONT class=invitetext><!----><!----><FONT color=#008000><SPAN style="FONT-SIZE: 12pt">Statistics Analysis Study</SPAN></FONT><SPAN style="FONT-SIZE: 12pt">)</SPAN></FONT></STRONG><SPAN style="FONT-SIZE: 12pt"> : </SPAN></FONT><A class=con_link href="http://cafe.daum.net/statsas" target=_blank><SPAN style="FONT-SIZE: 14pt"><FONT color=#810081 size=2><U><SPAN style="FONT-SIZE: 12pt">http://cafe.daum.net/statsas</SPAN></U></FONT></SPAN></A></P>
<P> </P>
<P><SPAN style="FONT-SIZE: 14pt"><FONT size=2><STRONG><SPAN style="FONT-SIZE: 12pt">백승민 홈페이지</SPAN></STRONG><SPAN style="FONT-SIZE: 12pt"> : </SPAN></FONT></SPAN><A class=con_link href="http://www.statwith.pe.kr/" target=_blank><SPAN style="FONT-SIZE: 14pt"><FONT color=#810081 size=2><U><SPAN style="FONT-SIZE: 12pt">http://www.statwith.pe.kr/</SPAN></U></FONT></SPAN></A></P>
<P> </P>
<P>
<TABLE height=1 cellSpacing=0 cellPadding=6 width=682 border=1>
<TBODY>
<TR vAlign=top bgColor=#ffffff>
<TD vAlign=top borderColor=#808080 align=left width=666 height=26><SPAN lang=ko><FONT color=#eea752 size=5><STRONG>- <FONT size=2>테이블 결합 ( 오라클 / PROC SQL / DATA STEP)</FONT></STRONG></FONT></SPAN></TD></TR>
<TR vAlign=top bgColor=#ffffff>
<TD vAlign=top borderColor=#ffffff align=left width=666 height=19>
<P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 5px"><FONT color=#0560a6 size=2><SPAN lang=ko> </SPAN></FONT><A class=con_link href="http://www.statwith.pe.kr/TABLE_JOIN/functions002.htm" target=_blank><FONT color=#0560a6 size=2><U>1. 예제 데이터 파일</U></FONT></A></P></TD></TR>
<TR vAlign=top bgColor=#ffffff>
<TD vAlign=top borderColor=#ffffff align=left width=666 height=19>
<P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 5px"><FONT color=#0560a6 size=2><SPAN lang=ko> </SPAN></FONT><A class=con_link href="http://www.statwith.pe.kr/TABLE_JOIN/functions003.htm" target=_blank><FONT color=#0560a6 size=2><U>2. 내부조인 (INNER JOIN)</U></FONT></A></P></TD></TR>
<TR vAlign=top bgColor=#ffffff>
<TD vAlign=top borderColor=#ffffff align=left width=666 height=19>
<P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 5px"><FONT color=#0560a6 size=2><SPAN lang=ko> </SPAN></FONT><A class=con_link href="http://www.statwith.pe.kr/TABLE_JOIN/functions004.htm" target=_blank><FONT color=#0560a6 size=2><U>3. 전체외부조인 (FULL JOIN)</U></FONT></A></P></TD></TR>
<TR vAlign=top bgColor=#ffffff>
<TD vAlign=top borderColor=#ffffff align=left width=666 height=19>
<P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 5px"><FONT color=#0560a6 size=2><SPAN lang=ko> </SPAN></FONT><A class=con_link href="http://www.statwith.pe.kr/TABLE_JOIN/functions005.htm" target=_blank><FONT color=#0560a6 size=2><U>4. 왼쪽 외부 조인 (LEFT JOIN)</U></FONT></A></P></TD></TR>
<TR vAlign=top bgColor=#ffffff>
<TD vAlign=top borderColor=#ffffff align=left width=666 height=19>
<P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 5px"><FONT color=#0560a6 size=2><SPAN lang=ko> </SPAN></FONT><A class=con_link href="http://www.statwith.pe.kr/TABLE_JOIN/functions006.htm" target=_blank><FONT color=#0560a6 size=2><U>5. 오른쪽 외부 조인 (RIGHT JOIN)</U></FONT></A></P></TD></TR>
<TR vAlign=top bgColor=#ffffff>
<TD vAlign=top borderColor=#ffffff align=left width=666 height=19>
<P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 5px"><FONT color=#0560a6 size=2><SPAN lang=ko> </SPAN></FONT><A class=con_link href="http://www.statwith.pe.kr/TABLE_JOIN/functions007.htm" target=_blank><FONT color=#0560a6 size=2><U>6. 교차조인 (CROSS JOIN)</U></FONT></A></P></TD></TR>
<TR vAlign=top bgColor=#ffffff>
<TD vAlign=top borderColor=#ffffff align=left width=666 height=19>
<P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 5px"><FONT color=#0560a6 size=2><SPAN lang=ko> </SPAN></FONT><A class=con_link href="http://www.statwith.pe.kr/TABLE_JOIN/functions008.htm" target=_blank><FONT color=#0560a6 size=2><U>7. 합집합 세로결합 (UNION)</U></FONT></A></P></TD></TR>
<TR vAlign=top bgColor=#ffffff>
<TD vAlign=top borderColor=#ffffff align=left width=666 height=1>
<P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 5px"><SPAN lang=ko><FONT color=#0560a6 size=2> </FONT></SPAN><A class=con_link href="http://www.statwith.pe.kr/TABLE_JOIN/functions009.htm" target=_blank><FONT color=#0560a6 size=2><U>8. 교집합 세로결합 (INTERSECT)</U></FONT></A><FONT size=2> </FONT></P></TD></TR>
<TR vAlign=top bgColor=#ffffff>
<TD vAlign=top borderColor=#ffffff align=left width=666 height=5>
<P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 5px"><SPAN lang=ko><FONT color=#0560a6 size=2> </FONT></SPAN><A class=con_link href="http://www.statwith.pe.kr/TABLE_JOIN/functions010.htm" target=_blank><FONT color=#0560a6 size=2><U>9. 차집합 세로결합 (MINUS)</U></FONT></A><FONT size=2> </FONT></P></TD></TR>
<TR vAlign=top bgColor=#ffffff>
<TD vAlign=top borderColor=#ffffff align=left width=666 height=5>
<P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 5px"><SPAN lang=ko><FONT color=#0560a6 size=2> </FONT></SPAN><A class=con_link href="http://www.statwith.pe.kr/TABLE_JOIN/functions011.htm" target=_blank><FONT color=#0560a6 size=2><U>10. 외부합집합(OUTER UNION)</U></FONT></A><FONT size=2> </FONT></P></TD></TR>
<TR vAlign=top bgColor=#ffffff>
<TD vAlign=top borderColor=#ffffff align=left width=666 height=4>
<P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 5px"><SPAN lang=ko><FONT color=#0560a6 size=2> </FONT></SPAN><A class=con_link href="http://www.statwith.pe.kr/TABLE_JOIN/functions012.htm" target=_blank><FONT color=#0560a6><FONT size=2><U>11. 배반 합집합 세로결합(EXCLUSIVE UNION) </U></FONT></FONT></A></P></TD></TR></TBODY></TABLE></P>
<!-- -->
]]>
카페 게시글
공지사항
테이블 결합 비교(오라클 / PROC SQL / DATA STEP)
백승민
추천 0
조회 1,112
08.11.17 01:31
댓글 1
다음검색
첫댓글 정말 좋은 글 입니다.