Member selection - Discount system
Member selections
Member selection
Name
Discount system
Active
Yes
Owned by system
No
Selection SQL
sELECT InternalNo FROM Member WHERE InternalNo IN (SELECT DISTINCT(InternalNo) FROM Memberdiscount WHERE Fromdate<=NOW() AND Todate>=NOW());
Members (6)
| Name | Member no | License info |
|---|---|---|
| Gerald 'Gary' Wilson | 2103 | 2026 / DEMO / D / HM AFF |
| Mr Crabs | 2104 | 2026 / DEMO / D / HM AFF |
| Patrick Star | 2101 | 2026 / DEMO / D / HM AFF |
| Sandy Cheeks | 2105 | 2026 / DEMO / D / HM AFF |
| SpongeBob SquarePants | 2100 | 2026 / DEMO / D / HM AFF |
| Squidward Tentacles | 2102 | 2026 / DEMO / D / AFF HM |