Hi all,

I have a master table and a child table 1 / n records.
Need to list a child table field in each table record master, and only the
first, second and third record of the child table.
Example:

Master Table:


Customer ID

Name


1

Jonhn


2

Rian





Child Table:


Customer ID

ProductID


1

1


1

2


1

3


1

4


1

5


2

3


2

7


2

6


2

2




Result:


Customer ID

Name

First Product ID of Customer 1

Second Product ID of Customer 1

Third Product ID of Customer 1


1

Jonhn

1

2

3


2

Rian

3

7

6


Thanks,

Davis



[Non-text portions of this message have been removed]