SQL & PL/SQL

Hi,

I have a requirement to get 4 columns as export. These 4 columns are in 4 tables (each table has only one column 'Name').

I have used below query for the same

select DR.name as BUDR,HQ.name as BUHQ,ME.name as BUME, SB.name as BUSB

  from (select name,rownum as rn from BU_01_VW) DR

      full outer join

     (select name, rownum as rn from BU_02_VW) HQ using (rn)

     full outer join

     (select name, rownum as rn from BU_03_VW) ME using (rn)

     full outer join

     (select name, rownum as rn from BU_04_VW) SB using (rn)

I get result as follows

for BUME , I get null values in between values, it's good for other columns.  Can one please suggest if I am missing something in the logic

Thanks in advance