目前有二個表單一個View如下...
表單English
----------------------------------------------
PID AnnPrice LimitPrice AgShow FullRecord
1 100 10 1 0
2 110 20 0 1
3 50 10 1 1
4 200 20 0 0
5 120 30 0 0
----------------------------------------------
表單Bid
--------------------
BidID PID BidPrice
a 1 110
b 1 130
c 1 140
d 3 140
e 3 200
f 5 150
g 5 300
--------------------
View
--------------------
PID DebitP PName
1 140 Key
2 300 Book
3 250 Tool
4 400 CD
5 300 Tap
--------------------
請問如何下語法獲得以下的View ??
(BidCount是計算在Bid中BidPrice或PID的次數)
------------------------------------------------
PID BidCount DebitP PName AgShow FullRecord
1 3 140 Key 1 0
2 300 Book 0 1
3 2 250 Tool 1 1
4 400 CD 0 0
5 2 300 Tap 0 0
------------------------------------------------
謝謝, 感恩... Orz
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 163.22.16.152