Problem with Query

emotionuk · #1 (**permalink**) 12-18-11, 08:38

Hello,

Can anyone tell me what's wrong with this query? I'm getting the following error:

"The select list of a grouped query contains at least one invalid expression"

Code:

"SELECT " + 
                    "CLOSEDCASH.HOST, " +
                    "CLOSEDCASH.HOSTSEQUENCE, " +
                    "CLOSEDCASH.MONEY, " +
                    "CLOSEDCASH.DATESTART, " +
                    "CLOSEDCASH.DATEEND, " +
                    "PAYMENTS.PAYMENT, " +
                    "SUM(PAYMENTS.TOTAL) AS TOTAL, TICKETS.TICKETID, RECEIPTS.DATENEW, PEOPLE.NAME " +
                    "FROM CLOSEDCASH, PAYMENTS, RECEIPTS, TICKETS, PEOPLE " +
                    "WHERE CLOSEDCASH.MONEY = RECEIPTS.MONEY AND PAYMENTS.RECEIPT = RECEIPTS.ID and RECEIPTS.ID=TICKETS.ID and TICKETS.PERSON = PEOPLE.ID AND ?(QBF_FILTER) " +
                    "GROUP BY CLOSEDCASH.HOST, CLOSEDCASH.HOSTSEQUENCE, CLOSEDCASH.MONEY, CLOSEDCASH.DATESTART, CLOSEDCASH.DATEEND, PAYMENTS.PAYMENT, TICKETS.TICKETID " +
                    "ORDER BY CLOSEDCASH.HOST, CLOSEDCASH.HOSTSEQUENCE, TICKETS.TICKETID");

Thanks,
Christian