有一张表, 数据如下
ID | NAME | PRICE | time
1 n1 1000 2011/11/11
2 n2 2000 2011/11/12
3 n3 8000 2011/11/13
查询理想结果
ID | NAME | PRICE | time | chajia
1 n1 1000 2011/11/11 0
2 n2 2000 2011/11/12 1000
3 n3 8000 2011/11/13 6000
ID | NAME | PRICE | time
1 n1 1000 2011/11/11
2 n2 2000 2011/11/12
3 n3 8000 2011/11/13
查询理想结果
ID | NAME | PRICE | time | chajia
1 n1 1000 2011/11/11 0
2 n2 2000 2011/11/12 1000
3 n3 8000 2011/11/13 6000
如此可行。。