This discussion is archived
0 Replies Latest reply: Jan 28, 2013 7:31 AM by 980979 RSS

Using left outer join in interface without ordered join

980979 Newbie
Currently Being Moderated
I have a problem with Left outer joins in interfaces.

None of the interfaces had ordered join option checked because the technology was set to non ordered sql.
I had to use the full outer join in one interface and I couldn't manage it with non ordered sql, so I changed it to ordered sql, implemented full outer join logic inside an interface and checked ordered join option.

The thing is, all of the interfaces that had left outer join logic now don't work because the ordered join is not checked. They are not throwing any errors, they just use inner join instead of left outer one.
There are more than 100 interfaces that use left outer join so it's not an easy job to manually change all of those interfaces, is there any quicker solution for this ?

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points