我在workbench里面进行sql查询
使用with语法出错
报错信息:
with a as
(SELECT p_id
FROM oncampus.post, oncampus.user
where (oncampus.post.u_id = oncampus.user.u_id)
) Error Code: 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 'a as
(SELECT p_id
FROM oncampus.post, oncampus.user
where (oncampus.post.u_id =' at line 1