please see attached -
fig a current output (select * from o_questions) and fig B the desired output.
I would like the assessments mee_id to repeat for every row of the assessment (ASM).
So the sql needs to check the assessments avd_data value (where the anv_name = 'MEE_ID') and repeat id for every row of the assessment.
It would use partition by but I need some more help on the syntax.