Hello, every one
I have two tables,
table one has the primary key is beneficiary_number
table two has the foreign key is follower_number
I want to join them , I wrote this query
select w.beneficiary_number ,
from oracle_waqf w JOIN
ON (w.beneficiary_number = f.follower_number)
where (w.beneficiary_number = 5 );
Now, the normal report will show me every person in a page,,,,
the different is in the name of the follower name,,,
what I want is
I want this query to be displayed as the following:
the details will be given from oracle_waqf table,
and the followers will be all in a list,,,
I am using Oracle report 6i
Use left outer join to get your requied output.
Left outer join is not supported by report 6i.
So you have create separate view at first then based on that view you can get your required output from report 6i.