Hi,

I've tried your axample and it works great except for that i get the following results;

Require;

TableA

TableB [one to many from TableA with an ID from Table A]

TableC [One to many from TableA with an ID from Table A] - Table B & Table C has nothing to do with Each Other

SQL query must show a record from Table A with ALL matching records from Table B as well as ALL matching records from table C.

Currently [before trying your example] i get TableA record BUT Duplicate records from TableB and Duplicate records from TableC [Somehow table B & TableC affects the result.

WITH YOUR EXAMPLE CODE i get TableC 100% correct [No Duplicated values]

TableB however, duplicates on either 1 of the valus returned.

from

TwoTables tt

left outer join QuickSpecMultiple c

on (tt.AId = c.id

and tt.rn = 1);

Changing the tt.rn = 1 to 2, moves the duplication to record 2, to 3 moves it to record 3 an so forth. The other results is NOT duplicated and displays correctly.