Mysql left join查询失败

最新推荐文章于 2023-04-13 22:28:30 发布

Leo.Wu

最新推荐文章于 2023-04-13 22:28:30 发布

阅读量778

点赞数 1

分类专栏： SQL 文章标签： mysql join 联合查询失败

本文链接：https://blog.csdn.net/lakyno/article/details/100638574

版权

SQL 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

错误的写法：

select f.cost, f.id, p.buy_cost from funcs f where f.id = 57 LEFT JOIN paid_vin p on p.func_id = f.id

总是报以下错误：

> 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 'LEFT JOIN

> 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 'RIGHT JOIN

正确的写法：

select f.cost, f.id, p.buy_cost from funcs f LEFT JOIN paid_vin p on p.func_id = f.id where f.id = 57