根据单个数据库查询中的条件增加值

I have a table which has a column labeled 'sortorder' which is used to allow customer to manually change the order of each item. The table also has a column labeled 'CategoryId'. I have a table which has a column labeled 'sort