菜鸟有问题请教,急!!!在线等
我有这么一张表pnbody,
BODYID PN
----------- -----------------------------------------------------
2 US2010289329 A1 20101118 DW201077
3 DE102010014588 A1 20101118 DW201077
4 DE102010017920 A1 20101118 DW201077
4 US2010288367 A1 20101118 DW201077
1 RU2404384 C2 20101120 DW201077
2 JP2010268594 A 20101125 DW201077
这表就bodyid,pn两列, bodyid是外键,和pn列是一对多的关系,我想问的是:怎样才能保证之后我查出数据时,控制相同bodyid的pn的和我添加时的顺序一样,例如bodyid = 2;这列 查询select * from pnbody order by bodyid 结果这样:
BODYID PN
----------- --------------------------------------------------------------------------------
1 RU2404384 C2 20101120 DW201077
2 US2010289329 A1 20101118 DW201077
2 FR2945685 A1 20101119 DW201077
2 JP2010268594 20101125 DW201077
3 DE102010014588 A1 20101118 DW201077