เล่นกับแบบดิบๆ เลย union สะเลย
with last as (
select x_.group , y_.no from cccc y_ , (select group from inw x_ where y_.item = x_item )
where x_group = 'A' and y_.no = '2'
union all
select x_.group , y_.no from cccc y_ , (select group from inw x_ where y_.item = x_item )
where x_group = 'B' and y_.no = '3'
union all
select x_.group , y_.no from cccc y_ , (select group from inw x_ where y_.item = x_item )
where x_group = 'C' and y_.no = '1' )
Load balance : Server 01
