C'est la requête que j'ai essayé d'écrire
select posts.* ,users.* FROM posts INNER JOIN users ON posts.user_id = users.id WHERE posts.user_id != '27' AND posts.pid EXISTS(SELECT post_id FROM favourites WHERE posts.pid=favourites.post_id)
C'est une erreur
select posts.* ,users.* FROM posts INNER JOIN users ON posts.user_id = users.id WHERE posts.user_id != '27' AND posts.pid EXISTS(SELECT post_id FROM favourites WHERE posts.pid=favourites.post_id) LIMIT 0, 25 MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'EXISTS(SELECT post_id FROM favourites WHERE posts.pid=favourites.post_id) LIM...' at line 6
![[Web front-end] Démarrage rapide de Node.js](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Vous devez utiliser
INau lieu de ÈXISTS.existe a une syntaxe différente
SELECT posts.*, users.* FROM posts INNER JOIN users ON posts.user_id = users.id WHERE posts.user_id != '27' AND posts.pid IN (SELECT post_id FROM favourites WHERE posts.pid = favourites.post_id) LIMIT 0 , 25Cela vérifiera s'il y a un identifiant de publication préférée
SELECT posts.*, users.* FROM posts INNER JOIN users ON posts.user_id = users.id WHERE posts.user_id != '27' AND EXISTS (SELECT post_id FROM favourites WHERE posts.pid = favourites.post_id) LIMIT 0 , 25