(case when a.qty != pas.qty1 then a.qty - pas.qty1
					else a.qty end ) as qty



			left join (
							select *, sum(qty) as qty1 from
							(
								select *, 1 as uploadflag from promats_allocation_status
								group by allocationid, promatsallocreasonid,isReturned
								union all
								select * from promats_allocation_status_save
								group by allocationid, promatsallocreasonid,isReturned
							)
							where PromatsAllocReasonID = 0
							group by allocationid, isReturned
					) pas
				on a.allocationid = pas.allocationid

select pas.AllocationID from
											(
												select *, sum(qty) as qty1 from
												(
													select *, 1 as uploadflag from promats_allocation_status
													group by allocationid, promatsallocreasonid,isReturned
													union all
													select * from promats_allocation_status_save
													group by allocationid, promatsallocreasonid,isReturned
												)
												group by allocationid, isReturned
											) pas
											inner join allocation a
												on a.AllocationID = pas.AllocationID
											where pas.qty1 = a.qty
											and pas.PromatsAllocReasonID = 0