select a.invadjustid,b.waresn from TInvAdjust a,tinvadjust b
where a.invadjustsn<>b.invadjustsn
and a.invadjustid=b.invadjustid
order by a.invadjustid desc
select a.invadjustid,b.waresn from TInvAdjust a,tinvadjust b
where a.invadjustsn<>b.invadjustsn
and a.invadjustid=b.invadjustid
order by a.invadjustid desc