作者jami520 (我的生命因你而发光)
看板Database
标题[SQL ] 简单的问题想请求帮忙!
时间Mon Oct 19 18:02:28 2009
===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
1F：→ PsMonkey:请改善标题 10/19 18:04