Есть 2 таблицы вида:


DEVICES
ID_DEVICE NAME
1                device1   
2                device2 
3                device3
4                device4

DATA
ID_DATA ID_DEVICE DATA
1             1                data1
2             1                data2
3             1                data3
4             2                data4 

Как мне выбрать по первые 3 строки из таблицы DATA для каждого DEVICES.ID_DEVICE

Например:
RESULT_TABLE
DEVICES.ID_DEVICE DATA.DATA
1                               data1
1                               data2
1                               data3  
2                               data4
............................................
...................
....