beedoc
beedoc copied to clipboard
多对多时,如何使用left join进行多表连接
type Post struct {
Id int
Title string
User *User orm:"rel(fk)"
Tags []*Tag orm:"rel(m2m)"
}
type Tag struct {
Id int
Name string
Posts []*Post orm:"reverse(many)"
}
var posts []*Post
num, err := dORM.QueryTable("post").Filter("Tags__Tag__Name", "golang").All(&posts)
像这样的查询,都是inner join 连接的,如果能用left join 连接呢