hibernate hql多表查询

hql多表查询包括类似原生SQL查询中的union和join多表联合，hql中这两种联合的查询方式相同
这里首先给出两表的实体结构和数据库结构
表users实体如下

@Entity
@Table(name = "users")
public class UserInfo {
	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	@Column(name = "id")
	private int id;
	
	@Column(name = "t_name")
	private String name;
	
	@Column(name = "password")
	private String password;
	
	public UserInfo() {}
	public UserInfo(String name, String password) {
		this.name = name;
		this.password = password;
	}
	public void setId(int id) {
		this.id = id;
	}
	public int getId() {
		return this.id;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getName() {
		return this.name;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getPassword() {
		return this.password;
	}
}

users表结构如下

+----------&#