Sorry! There is no shop registered in table WT007 Select C006,C002,C005,C000, 1 as OrderCol from WT007 (nolock)  where C000=-1 UNION  Select C006,C002,C005,C000, 2 as OrderCol from WT007 (nolock)  where C005=0 UNION  Select C006,C002,C005,C000, 3 as OrderCol from WT007  Order by OrderCol, C000    Provider=SQLOLEDB.1;Data Source=SERVER19;Initial Catalog=WEBEDITION;User ID=meso;Password=Blego2524!;Persist Security Info=True