Wrong result with Outer Join

Discussion regarding older releases of SQLBase.

Wrong result with Outer Join

Postby FRBhote » Wed Dec 21, 2016 12:31 am

On SB 8.5 with an outer join I do not get the max date - only the first date.

When I remove the MAX, the outer join returns one row, whereas without the outer join I get 4 rows. This is crazy!

OJ.png
You do not have the required permissions to view the files attached to this post.
User avatar
FRBhote
 
Posts: 977
Joined: Mon Jul 07, 2008 7:38 am
Location: Hyderabad, India

Return to Older Releases

Who is online

Users browsing this forum: No registered users and 1 guest