select * from

(select sum(amount) as sorgu1 from current where productspk in (select pk from products where categorypk = 1) and motion = 1)  as t1

join

 (select sum(amount*pricedollar) as sorgu2 from current where productspk in (select pk from products where categorypk = 1) and motion = 1)as t2  

join 

(select sum(amount) as sorgu3 from current where productspk in (select pk from products where categorypk = 1) and motion = 0 ) as t3

join 

(select sum(amount*pricedollar) as sorgu4 from current where productspk in (select pk from products where categorypk = 1) and motion = 0  )as t4