SELECT
admin_help_cate_o1.text AS cate_text,
admin_help.*
FROM
admin_help
LEFT JOIN admin_help_cate admin_help_cate_o1 ON admin_help_cate_o1.id = admin_help.cate_id
WHERE
admin_help.row_id > 0
ORDER BY
admin_help.displayorder ASC写了个类似的$rows = Db::table('admin_help')->field('admin_help_cate_o1.text as cate_text, admin_help.*')
->join('LEFT JOIN admin_help_cate admin_help_cate_o1 on admin_help_cate_o1.id = admin_help.cate_id')
->where($condition)
->page($page_number, $page_size)
->select();但QUERY不认，join出错。
查了最新的文档，没发现JOIN的用法，请指导一下，多谢
最佳答案
