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

Selection SQL

sELECT InternalNo FROM Member WHERE InternalNo IN (SELECT InternalNo FROM Membermessage WHERE MessageType=300 AND (Removed>NOW() OR Removed IS NULL));

Members (1)

   Name    Member no    License info
   Penelope Clearwater    2124    2025 / DEMO / D / HM AFF