You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Mar 28, 2020. It is now read-only.
Ho can i do inner join or query with " ... WHERE NOT EXISTS ... "?
My query is that:
SELECT id, *, *, *, *, *,* FROM $tblPosts WHERE NOT EXISTS (SELECT whoBlock FROM $tblBlock WHERE user_id = whoIsBlock AND whoBlock = $id) AND NOT EXISTS (SELECT whoBlock FROM $tblBlock WHERE user_id = whoBlock AND whoIsBlock = $id) AND deleted = FALSE ORDER BY date DESC
Ho can i do inner join or query with " ... WHERE NOT EXISTS ... "?
My query is that:
SELECT
id,*,*,*,*,*,*FROM$tblPostsWHERE NOT EXISTS (SELECT whoBlock FROM $tblBlock WHERE user_id = whoIsBlock AND whoBlock = $id) AND NOT EXISTS (SELECT whoBlock FROM $tblBlock WHERE user_id = whoBlock AND whoIsBlock = $id) ANDdeleted= FALSE ORDER BY date DESC