这是一个创建于 3028 天前的主题,其中的信息可能已经有所发展或是发生改变。
我运行
SELECT * FROM company
WHERE company.apply_id = 1
和
SELECT * FROM apply
WHERE apply.apply_id = 1
都没有问题,但是为什么运行
SELECT DISTINCT
apply.client_name AS 客户姓名,
apply.client_id AS 客户 ID,
company.company_name AS 公司名称,
company.company_province_name AS 公司省,
company.company_city_name AS 公司市,
company.company_county_name AS 公司县区,
company.company_other AS 公司其他,
company.department AS 部门,
company.office_level_name AS 职位,
company.salary AS 月薪,
company.other_income AS 其他收入,
company.industry_name AS 行业,
company.nature AS 单位性质,
company.company_size AS 公司规模
FROM
apply
INNER JOIN company.apply_id = apply.apply_id
的时候,就提示
[Err] 1064 - 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 '.apply_id' at line 18
求解 QAQ ,究竟是哪里错了?
|
|
1
jy01264313 2016-08-19 09:59:53 +08:00
大哥,你 join 完全不对啊
|
|
|
2
jy01264313 2016-08-19 10:00:27 +08:00
上面没写完, join table on
|