JOIN
: 두개의 테이블을 연합해서 데이터를 출현하는 것
연습문제) 조회결과 작성자의 ID, 이름, 나이, 제목, 날짜까지 확인하고 싶을때
- * SELECT 약어.항목명, 약어.항목명, 약어.항목명, 약어.항목명
FROM 테이블명 약어, 테이블명 약어
WHERE 약어.항목명 = 약어.항목명;
- * FROM 테이블명 약어, 테이블명 약어: 약어 설정
오타를 줄일 수 있고 간편함
같은 이름의 항목이 존재할 수 있으니 테이블 약식이름을 써서 항목명을 명시
약어 설정후 사용
JOIN 사용
%2520Join%26logoUrl%3Dhttps%253A%252F%252Finblog.ai%252Finblog_logo.png%26blogTitle%3Dvosw1&w=3840&q=75){kind=logo}
%2520%25EB%25AC%25B8%25EC%259E%2590%25EC%2597%25B4%26logoUrl%3Dhttps%253A%252F%252Finblog.ai%252Finblog_logo.png%26blogTitle%3Dvosw1&w=750&q=75){kind=logo}
%2520%25EC%2599%25B8%25EB%259E%2598%25ED%2582%25A4%2520(2)%26logoUrl%3Dhttps%253A%252F%252Finblog.ai%252Finblog_logo.png%26blogTitle%3Dvosw1&w=750&q=75){kind=logo}
%2520%25EC%2599%25B8%25EB%259E%2598%25ED%2582%25A4%2520(1)%26logoUrl%3Dhttps%253A%252F%252Finblog.ai%252Finblog_logo.png%26blogTitle%3Dvosw1&w=750&q=75){kind=logo}
%2520%25EC%2583%2598%25ED%2594%258C%2520%25EB%258D%25B0%25EC%259D%25B4%25ED%2584%25B0%2520%25EC%259D%25B4%25EC%259A%25A9%26logoUrl%3Dhttps%253A%252F%252Finblog.ai%252Finblog_logo.png%26blogTitle%3Dvosw1&w=750&q=75){kind=logo}
%2520%25EB%25AC%25B8%25EC%259E%2590%25EC%2597%25B4%26logoUrl%3Dhttps%253A%252F%252Finblog.ai%252Finblog_logo.png%26blogTitle%3Dvosw1&w=256&q=75){kind=logo}
%2520%25EC%2599%25B8%25EB%259E%2598%25ED%2582%25A4%2520(2)%26logoUrl%3Dhttps%253A%252F%252Finblog.ai%252Finblog_logo.png%26blogTitle%3Dvosw1&w=256&q=75){kind=logo}
%2520%25EC%2599%25B8%25EB%259E%2598%25ED%2582%25A4%2520(1)%26logoUrl%3Dhttps%253A%252F%252Finblog.ai%252Finblog_logo.png%26blogTitle%3Dvosw1&w=256&q=75){kind=logo}
%2520%25EC%2583%2598%25ED%2594%258C%2520%25EB%258D%25B0%25EC%259D%25B4%25ED%2584%25B0%2520%25EC%259D%25B4%25EC%259A%25A9%26logoUrl%3Dhttps%253A%252F%252Finblog.ai%252Finblog_logo.png%26blogTitle%3Dvosw1&w=256&q=75){kind=logo}