有人能告诉我这里的语法错误是什么吗?
`SELECT T.id,T.vmProductID,T.name AS Course,C.title AS Category FROM j25_lms_tests AS T LEFT JOIN j25_lms_categories AS C ON C.id = T.catid WHERE T.published=1 AND T.vmProductID IN() ORDER BY T.ordering`
这是脚本的主要代码:
'SELECT T.id,T.vmProductID,T.name AS Course,C.title AS Category FROM #__lms_tests AS T
LEFT JOIN #__lms_categories AS C ON C.id = T.catid
WHERE T.published=1 AND T.vmProductID IN($vmProductIds) $Catwhere
ORDER BY T.ordering";'
谁能告诉我代码有什么问题?
先谢谢你了
1条答案
按热度按时间zlhcx6iw1#
IN
子句没有值: