使用builder生成的 JOIN 连表查询语句用xorm进行查询，查询的字段与实际的字段不一样 #1747

New Issue

conero · 2020-07-26T14:21:55Z

conero commented

2020-07-26 14:21:55 +00:00

连表查询示例

vsqlMk := builder.Select("cur.id", "u.name", "m.name member", "cur.status", "cur.is_admin", "cur.ctime",
			"cu.name cname").
			From("clan_user_ref", "cur").
			InnerJoin("clan c", "cur.clan_id = c.id").
			InnerJoin("user u", "cur.user_id = u.id").
			InnerJoin("user cu", "cur.cuid = cu.id").
			LeftJoin("clan_member m", "cur.member_id = m.id").
			Where(builder.Eq{"cur.del_mk": 0, "cur.clan_id": clanId}).
			OrderBy("cur.ctime desc")


//方式1
sqlAndBinds := []interface{}{vSql}
sqlAndBinds = append(sqlAndBinds, args...)
data, er = db.QueryInterface(sqlAndBinds...)

//方式2
//er = db.SQL(vSql, args...).Find(&data)

两者查询的结果相同，但是与实际的sql执行完全不同

**连表查询示例** ```go vsqlMk := builder.Select("cur.id", "u.name", "m.name member", "cur.status", "cur.is_admin", "cur.ctime", "cu.name cname"). From("clan_user_ref", "cur"). InnerJoin("clan c", "cur.clan_id = c.id"). InnerJoin("user u", "cur.user_id = u.id"). InnerJoin("user cu", "cur.cuid = cu.id"). LeftJoin("clan_member m", "cur.member_id = m.id"). Where(builder.Eq{"cur.del_mk": 0, "cur.clan_id": clanId}). OrderBy("cur.ctime desc") //方式1 sqlAndBinds := []interface{}{vSql} sqlAndBinds = append(sqlAndBinds, args...) data, er = db.QueryInterface(sqlAndBinds...) //方式2 //er = db.SQL(vSql, args...).Find(&data) ``` *两者查询的结果相同，但是与实际的sql执行完全不同* ![image](/attachments/b7b432c8-d42f-46a2-b16e-bc31b4ad1d44) ![image](/attachments/71abd54b-fdb5-4051-ae1e-10c929689e30)

image.png

34 KiB

image.png

31 KiB

image.png

50 KiB