어차피 조건으로 들어가는 건들은 나와있는 형태이니

하기 형태대로 처리하시는게 제일 편할듯하네요.

----쿼리시작----

with tblA (ID,num,val) As
(
       Select '4605','1300','100001' Union All
       Select '4606','1100','100002' Union All
       Select '4607','0501','100006' Union All
       Select '4608','1100','100008'
)
,tblB (ID) As
(
       Select '4605'  Union All
       Select '4606'  Union All
       Select '4607'  Union All
       Select '12345'
)
    Select
           a.*
      From
           (
           --1. 조건에 부합되는 자료
               Select a.ID    As ID
                     ,a.num   As num
                     ,a.val   As val
                     ,1       As seq
                 From tblA a
                Where a.ID In (
                                 '4605'
                                ,'4606'
                                ,'4607'
                                ,'12345'
                              )           
          
             Union All            
            
           --2. 조건에 부합되지 않는 자료
               Select a.ID    As ID
                     ,NULL    As num
                     ,NULL    As val
                     ,2       As seq
                 From tblB a
                Where Not Exists (
                                      Select 'x'
                                        From tblA b
                                       Where a.ID = b.ID
                                 )
           ) a
  Order By a.seq Asc

----쿼리끝----