Thanks for the response. The thing is ux has many mx's each mx has one mc. So each ux has many mc's. I am trying to get uc and related mc's in a single record. Hence, I did something like this.
select ux.unit_slno,
ux.catalog_no,
ux.unit_status,
ux.prepare_date,
ux.prepared_by...