[sql server] cross apply inner join, left join, cross apply 의 결과 차이를 확인----------------------------------------------------------------------------------------- if object_id('tempdb..#test') is not nulldrop table #test if object_id('tempdb..#testOne') is not nulldrop table #testOne create table #test (id int, ename nvarchar(20)) create table #testOne (id int, test_id int, pname nvarchar(20)) insert into #testvalues (1, .. 더보기 이전 1 2 3 4 5 6 7 ··· 65 다음