SQL Query to extract those data that have no profile code

Select distinct
papf.person_number,profile_code
from PER_ALL_PEOPLE_F PAPF, HRT_PROFILES_B HPB
where
PAPF.PERSON_ID = HPB.PERSON_ID
AND Profile_Code is NULL

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

Technical Contents - SQL Query
Posted by : Mohammad
Follow on Linkedin