[Solved] SQL Inner Join not exist

Question

select  distinct pt.tagname
from    post_tag pt
where   not exists
        (
        select  *
        from    post_category pc
        where   pc.post_id = pt.post_id
        )

Accepted Answer

select  distinct pt.tagname
from    post_tag pt
where   not exists
        (
        select  *
        from    post_category pc
        where   pc.post_id = pt.post_id
        )