How to list of all Crew Missing Passport Details in Merlot

Owned by Pawandeep Singh (Deactivated)
Last updated: 09/03/2023 by Mark Dignadice (Unlicensed)
1 min read

This script can be used to find all the crew members that do not have passport details listed in Merlot.

Step-by-step guide

Execute the below script against the customer DB.

select * from employee where id not in (select employeeid from EmployeeDocument where DocumentTypeId = 10) and Active = 1