使用mabatis多表查询,发现报错: Column 'id' in where clause is ambiguous。
Column 'id' in where clause is ambiguous。的意思是:列"id"是模棱两可的。
sql语句:select psc.* ,ssc.id as sscid,c.course_name from t_parent_select_course psc left join t_school_select_course ssc on psc.school_sel_course_id=sscid left join t_course c on ssc.courseid=c.id where id=1
原来是2张表都有id字段,应该指定是哪一张表的id。