Hello all,
I am creating new IDT with two tables T1 and T2.
The join between two tables is T1.ID=T2.ID. I selected left side outer join check box(My meaning is to get everything from T1 table and matched records from T2)
When I view the sql script(after saving the dfx), I see a right outer join(designer just shifted tables left to right and made as right outer join) There is nothing wrong with query but I just like to see left outer join.
I tried enabling ANSI92 to yes based on BOBJ forum suggestions but so far no luck.
NMlakshmi (BOB member since 2017-10-24)