I'm not sure what is "priority" in this case. The following query will eliminate batches from subsequent temp tables that already exist in previous temp. tables

Select * From #TTCompletePoint
Union All
Select * From #TTComplete
  Where iBatchID Not In (Select * From #TTCompletePoint)
Union All
Select * From #TTFailed
  Where iBatchID Not In (Select * From #TTCompletePoint)
    And iBatchID Not In (Select * From #TTComplete)
Union All
Select * From #TTInprocess
  Where iBatchID Not In (Select * From #TTCompletePoint)
    And iBatchID Not In (Select * From #TTComplete)
    And iBatchID Not In (Select * From #TTFailed)

>I have four seperate queries and want to join them into a single result set, giving the first result set priority over the first. Can anyone help?