Do you mean there will be a maximum of three 'child' records per parent record?.....

Yes, a maximum of 3 child rows per parent.

I had tried aliasing the child rows but there is no specific where clause I can use to limit to a specific selection of the available children. Just retrieving 3 is the only requirement as there are rarely more than 3 and often none. My attempts at coding this so far have not given me the results I wanted. a simple example of what I want to do would be ...........

Table A_TABLE Table B_TABLE

A1_COL B1_COL

B2_COL

B3_COL

RESULT SET CONTAIN....

A1,B2,B3,B2,B3,B2,B3

Where columns A1 and B1 would be the primary and foreign keys.

Thanks!