Id -13, updated 12/12/25, 11:31 AM/master
Member selection - intlistPilot
SkyViewMember selections Create a copy
Name:
intlistPilot
Active:
No
Owned by system:
Yes

Selection SQL

sELECT InternalNo FROM Member WHERE Pilot='Y' OR InternalNo IN (SELECT InternalNo FROM Loadrole WHERE RoleType='PILOT');

Members (5)

   Name    Member no    License info
   Amelia Earhart    2151    
   Charles Lindbergh    2152    
   Elsa Teresia Andersson    2153    
   Orville Wright    2155    
   Wilbur Wright    2154