Code: Select all
SELECT
`receipts`.`DATENEW`,
`products`.`REFERENCE`,
`products`.`NAME`,
`ticketlines`.`UNITS`,
`products`.`PRICESELL` FROM `epos`.`ticketlines` AS `ticketlines`,
`epos`.`products` AS `products`, `epos`.`tickets` AS `tickets`,
`epos`.`receipts` AS `receipts`, `epos`.`categories` AS `categories`,
`Madison ID` WHERE `ticketlines`.`PRODUCT` = `products`.`ID`
AND `ticketlines`.`TICKET` = `tickets`.`ID`
AND `tickets`.`ID` = `receipts`.`ID`
AND `products`.`CATEGORY` = `categories`.`ID`
AND `categories`.`PARENTID` = `Madison ID`.`ID`
AND `receipts`.`DATENEW` BETWEEN {D '2015-06-15' } AND {D '2015-06-21' }
Code: Select all
`DATENEW` BETWEEN :enter_date_from AND :enter_date_to
SQL Status: S1009
Parameter index out of range (1 > number of parameters, which is 0).
Can anyone help?