1,当多个表中存在相同的字段,查询时要使用别名,否则程序无法区分,如下:
val sql = """ |select |a.id as a_id,a.name as name,b.id as b_id,b.score as score //如果两个表有些字段相同,在查询时要使用别名,程序无法识别 |from stu a |left join score b |on a.id = b.id """.stripMargin
1,当多个表中存在相同的字段,查询时要使用别名,否则程序无法区分,如下:
val sql = """ |select |a.id as a_id,a.name as name,b.id as b_id,b.score as score //如果两个表有些字段相同,在查询时要使用别名,程序无法识别 |from stu a |left join score b |on a.id = b.id """.stripMargin