MySQL加入问题
我正在建立一个小型系统,用于跟踪分配给请求的人员。
我的表结构如下所示:
表:requests
- RequestID
- RequestDetails
表:request_staff
- RequestID
- StaffUserID
显然RequestID用于链接到两个表。
我想选择对一名工作人员的所有请求。我的理解是,加入将是最好的方法...
SELECT *
FROM `request_staff`,`requests`
WHERE 'RequestID'.`request_staff` = 'RequestID'.`requests`;
我收到一条错误消息:
您的 SQL 语法有错误;检查与您的 MySQL 服务器版本相对应的手册,了解在第 3 行的 '.
request_staff
= 'RequestID'.requests
' 附近使用的正确语法
感谢您的帮助!
I'm setting up a small system that keeps track of which person is assigned to a request.
My table structure looks like this:
Table: requests
- RequestID
- RequestDetails
Table:request_staff
- RequestID
- StaffUserID
Obviously RequestID is used to link to the two tables.
I want to select all requests for a staff member. My understanding is that a join would be the best method...
SELECT *
FROM `request_staff`,`requests`
WHERE 'RequestID'.`request_staff` = 'RequestID'.`requests`;
I'm getting an error message of:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.
request_staff
= 'RequestID'.requests
' at line 3
Thanks for your help!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
您的 where 语句中的字段/表是向后的。应该是 request_staff.RequestID = requests.RequestID
You have the fields/tables backwards in your where statement. Should be request_staff.RequestID = requests.RequestID
我认为你应该这样尝试:
你将字段和表名称颠倒了。
I think you should try it like this:
You had the field and table names reversed.