Member selection - Discount system
Member selections
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 | 2025 / DEMO / D / HM AFF |
| Mr Crabs | 2104 | 2025 / DEMO / D / HM AFF |
| Patrick Star | 2101 | 2025 / DEMO / D / HM AFF |
| Sandy Cheeks | 2105 | 2025 / DEMO / D / HM AFF |
| SpongeBob SquarePants | 2100 | 2025 / DEMO / D / HM AFF |
| Squidward Tentacles | 2102 | 2025 / DEMO / D / HM AFF |