Sorry if this sounds vague … I have searched for the answer for this but, am finding it hard to explain – therefore hard to search for.
I have a really simple script…
select pr1.polypart_no match_from, pr1.part_no match_to from oes_polybox_replace pr1 where pr1.plant = 'W' and pr1.part_no = (select max(pr2.part_no) from oes_polybox_replace pr2 where pr2.plant = 'W' and pr2.polypart_no = 'YPOLYGREY')
…that shows in column 1, a part number and in column 2, a generic part that can be used in place of the part number in column 1.
My issues is I need to add the part in column 2 to column 1, i.e.
Is there a way a add 2 select’s to one column?