• i tried with full outer join but not getting the result