COALESCE ( expression [ ,...n ] ) : 인수 중에서 Null이 아닌 첫 번째 식을 반환합니다.
와 Full Outer Join 을 이용하시면 원하시는 결과를 만드실수 있을겁니다.


with  tbPackLimit
as (
select 47 iUserID, 1  sPackIndex ,'2009-02-13 17:44:00'  tmLimit union all
select 47 iUserID, 2  sPackIndex ,'2009-02-14 08:16:00'  tmLimit ) ,

tbPackName
as (
   
select 47 iUserID ,0 sPackIndex ,'Pack Name 0'  szPackName union all
select 47 iUserID ,2 sPackIndex ,'Pack Name 2'   szPackName )

 select  COALESCE (a.sPackIndex,b.sPackIndex) sPackIndex
        ,isnull(b.szPackName ,'' ) szPackName
        ,isnull(a.tmLimit,'' ) szLimit
   from tbPackLimit a  Full Outer Join tbPackName b  on a.sPackIndex =b.sPackIndex
  order by COALESCE (a.sPackIndex,b.sPackIndex)