我在SELECT部分中编写了一个带有子查询的语句,但是我得到了以下错误消息(从Codeigniter返回):
您的SQL语法出现错误;请检查与您的MySQL服务器版本对应的手册,以获得使用near‘的正确语法(从product_selects中选择ps_id = '1'),在第1行选择psc_opt_2 A
`psc_opt_1` AS (SELECT `ps_url_name` FROM `product_selects` WHERE `ps_id` = '1
| 0.01SELECT period, loan_sum, covers, delay (SELECT MAX(EXTRACT(YEAR_MONTH FROM psc.datepayment_schedule_row AS psr2 WHERE psr.payment_schedule_id = psr2.payment_schedule_id) AS loan_sum,
(SELECT SUM(psc2.sum) FROM payment_schedule_cover AS psc2 WHER
这个mysql查询提供了按一天中的天数和小时分组的产品销售数量(总计和total_staff)。我想要每个产品的总和和total_staff (不是按任何东西分组,而是按id进行期望)。s.staff=1 THEN 1 ELSE 0 END) as total_staffLEFT JOIN products_subCategories pscON msc.id=psc.manifSubCategory_id
LEFT JOIN sales s ON psc.pro