as와 join 을 동시에

join을 하고 as 를 동시에 하기!

select employeeName, departmentName, publishedDate, snackName, ticketWeight from(
select EMP_NM as employeeName, DPT_NM as departmentName, PBL_DT as publishedDate, 

SNK_NM as snackName, TCK_WGH as ticketWeight

from tb_ticket
join tb_emp on tb_emp.EMP_CD = tb_ticket.EMP_CD
join tb_snack on tb_snack.SNK_CD = tb_ticket.SNK_CD)
ticket;