→ PsMonkey:請改善標題 10/19 18:04
===lorenzo_stok資料表===
pno
pname
stok_num
branch
資料
pno pname stok_num branch
A123 John 3 A
D456 Tom 5 B
........
===lorenzo_preorder資料表===
pno
branch
preorder_no
資料
pno branch preorder_no
A123 1 W324
A123 2 R321
.......
===lorenzo_branch資料表===
bid
branch_name
資料
bid branch_name
1 A
2 B
......
我目前想做的是把lorenzo_stok資料表的branch先藉由對應lorenzo_branch轉為數字，再與
lorenzo_preorder做聯集
以下是我寫的MySQL語法，不過有錯誤產生，不知道各位可以幫忙看一下嗎? 感謝!
SELECT lorenzo_stok.pno, lorenzo_stok.pname, lorenzo_stok.stok_num,
lorenzo_preorder.preorder_no, (SELECT lorenzo_branch.bid FROM lorenzo_branch
WHERE lorenzo_branch.branch_name=lorenzo_stok.branch) as 'cnum' FROM
lorenzo_stok INNER JOIN lorenzo_preorder ON
lorenzo_stok.pno=lorenzo_preorder.pno AND cnum=lorenzo_preorder.branch WHERE
lorenzo_stok.pno = %s ORDER BY lorenzo_stok.branch ASC
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 218.166.210.9