How can I compare two tables in MySQL on WordPress?

SELECT wp_posts.* FROM wp_posts LEFT OUTER JOIN wp_npn_profile_list ON wp_posts.id = wp_npn_profile_list.profile_id WHERE wp_posts.post_type = 'profile' AND wp_npn_profile_list.profile_id IS NULL;