獲取ORA-00918：列定義不明確：運行此SQL：SELECT *FROM (SELECT DISTINCT(coaches.id), people.*, users.*, coaches.* FROM "COACHES" INNER JOIN people ON people.id = coaches.person_id INNER JOIN users ON coaches.person_id = users.person_id LEFT OUTER JOIN organizations_users ON organizations_users.user_id = users.id) WHERE rownum <= 25有什么建議嗎？
ORA-00918：列在SELECT中含糊*
當年話下
2019-11-03 15:04:39
