我无法让mysql中的join函数工作

gk7wooem  于 2023-05-05  发布在  Mysql
关注(0)|答案(1)|浏览(187)

有人能告诉我这里的语法错误是什么吗?

`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";'

谁能告诉我代码有什么问题?
先谢谢你了

相关问题