ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] MS SQL full join°ÝÃD

[µo°Ý] MS SQL full join°ÝÃD

--MS SQL full join°ÝÃD
declare @t1 table (f1 nvarchar(50), f2 nvarchar(50))
declare @t2 table (f1 nvarchar(50), f3 nvarchar(50))
declare @t3 table (f1 nvarchar(50), f4 nvarchar(50))
insert into @t1 (f1,f2) values ('a','1')
insert into @t1 (f1,f2) values ('c','2')
insert into @t1 (f1,f2) values ('d','3')
insert into @t2 (f1,f3) values ('a','4')
insert into @t2 (f1,f3) values ('b','5')
insert into @t2 (f1,f3) values ('d','6')
insert into @t3 (f1,f4) values ('c','7')
insert into @t3 (f1,f4) values ('e','8')
--select t1f1=t1.f1,t2f1=t2.f1,t3f1=t3.f1,f2,f3,f4
select f1=isnull(t1.f1,isnull(t2.f1,t3.f1)),f2,f3,f4
from @t1 t1
full join @t2 t2 on t1.f1=t2.f1
full join @t3 t3 on t2.f1=t3.f1
order by f1
¤W¦Cµ²ªG¦p¹Ï1,f1ªº­È¦³'c'­«½Æ
¦p¦ó¯à¦³¹Ï2ªºµ²ªG? (f1¤£­n­«½Æ)
§Úª¾¹D§ï¦¨
select f1=isnull(t1.f1,isnull(t2.f1,t3.f1)),f2,f3,f4
from @t1 t1
full join @t2 t2 on t1.f1=t2.f1
full join @t3 t3 on t1.f1=t3.f1
order by f1
¯à¹F¨ì¥Øªº,¦ý³o¬O¥©¦X,¤£«OÀI,
¦]¬°¹ê°È¤W¦Utable­È«Ü¦h,µLªk¤@¤@¥hÀˬd¦³­þ¨Ç·|¨S¹ïÀ³¨ì
½Ð°Ý¦³¨S¦³ªv¥»¤§¹D?

¹Ï:
https://drive.google.com/file/d/0B43q2SqHw8xcUlRZVnZuaHViUjQ/view
Symis

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD