Topic: Report SQL error
Hello,
What's error in the code? How to fix?
Thanks, carlo
SELECT
members.Paid
,members.firstname
,members.lastname
,members.ClubID < Report SQL = OK
,members.StartBet
,members.EndBet
,members.eMail
,members.GSM
,members.Comments,
members.id FROM members
<---------------------------------> But with this Boolean convert = CASE= syntax error
CASE Paid WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' ELSE '' END
FROM members