SELECT连表查询重复字段

连表查询不用SELECT * 直接用 SELECT FIELD 列字段，错误：两个表出现重复的两个字段userId：

Cause: java.sql.SQLIntegrityConstraintViolationException: Column 'userId' in field list is ambiguous

eg: 两个表blog和user连表查询：

select
	userId,publishDateTime,blogId,blogTitle,blogContent
from blog
	inner join user on blog.userId=user.userId
order by
	publishDateTime desc limit #{page},#{limit}

（1）、第一种，只保留其中一个字段：

select
	blog.userId,publishDateTime,blogId,blogTitle,blogContent
from blog
	inner join user on blog.userId=user.userId
order by
	publishDateTime desc limit #{page},#{limit}

（2）、第二种，保留两个字段，起别名：

select
	blog.userId as userId,user.userId as uid,publishDateTime,blogId,blogTitle,blogContent
from blog
	inner join user on blog.userId=user.userId
order by
	publishDateTime desc limit #{page},#{limit}

  保证结果有自己起的别名属性字段

（3）、第三种，给表起别名：

select
	bb.userId,uu.userId as uid,publishDateTime,blogId,blogTitle,blogContent
from blog bb
	inner join user uu on bb.userId=uu.userId
order by
	publishDateTime desc limit #{page},#{limit}
	
或者加上as：

select
	bb.userId,uu.userId as uid,publishDateTime,blogId,blogTitle,blogContent
from blog as bb
	inner join user as uu on bb.userId=uu.userId
order by
	publishDateTime desc limit #{page},#{limit}