Joining 2 folders in 2 different ways

[cogjai]

Hi all,

I am selecting few fields from 2 folders for a report. Its relating fields by equi join. For another report, i need left join for these 2 folders. Is it possible two join two folders in 2 differet kind of relations.

any other ideas please.

thanks

 

[drlex]

If you have access to the catalogue or can create your own one, this appears to be a good case for aliasing one of the tables so that the alternative join can be made between the first table and the alias of the second.
Otherwise, as per another of your threads, you can modify the SQL generated and used in the report.

"Time flies like an arrow, but fruit flies like a banana."