如何将一条记录分成两条记录呢，在线等待，急！！

[handyworkroom]

在下面的一条记录
store表
storedate dining cent1 room cent2
2003-8-29 233.70 2 680.00 3

如何用SQL写，将记录分成两条记录
storedate item money cent
2003-8-29 dining 233.70 2
2003-8-29 room 680.00 3

[zjcxc]

select storedate,item='dining',ding,cent=cent1 from store
union all
select storedate,item='room',ding,cent=cent2 from store

[handyworkroom]

还有别的写法吗？

[pinghell]

这样可以呀

[handyworkroom]

这样写的话，数据就不是按时间排的了，我想让它们有联系的（时间相同的）显示在一前一后，

[zjcxc]

你可以加个排序语句就行了嘛:

select storedate,item='dining',ding,cent=cent1 from store
union all
select storedate,item='room',ding,cent=cent2 from store
order by storedate

[lyguo]

select storedate,item='dining',ding,cent=cent1 from store
union all
select storedate,item='room',ding,cent=cent2 from store
order by storedate


楼上说的不错