BusinessObjects Board

inner join - free-hand sql queries

building reports desktopintelligence
#1

Hello,

I wasn’t able to find a similar problem on this forum so maybe it is trivial.
Anyway, i try to combine two free-hand sql queries. I connect them through one of the ID fields but when i try to display data from both of them i can’t handle a number of rows returned.

For instance if one of the queries returns 10 rows and the other 20 I am not able to show only 10 rows from the first one and 10 corresponding from the second. When I set first one as a higher in query hierarchy it shows me 10 rows + additional 10 which are empty.

thans for any help

wojnarabc :poland: (BOB member since 2007-11-07)

#2

Hi, your question is fairly similar to this FAQ entry, hope it helps. :slight_smile:

Dave Rathbun :us: (BOB member since 2002-06-06)