Find Orders With Multiple Tax ID By Item


select sopnumbe from sop30300 
group by sopnumbe
having (select count(distinct taxschid)) > 1 and sopnumbe not like 's%' and sopnumbe not like '%q%'
order by sopnumbe desc

select taxschid,* from sop30300 where sopnumbe = 'J4253'
select taxschid,* from sop30300 where sopnumbe = 'J4278'
select custnmbr,* from sop30200 where sopnumbe = 'B2655'
select * from rm00101 where custnmbr = 'TEGAPA7033'

Leave a Reply