我有3个表来表示我的多对多关系。客户、公司、companies_customers。
companies:
- id
- name
customers:
- id
- username
companies_customers:
- id
- customer_id
- company_id现在,我想要运行的查询是选择所有company_id为1的客户。
SELECT * FROM customers c INNER JOIN customers_companies cc ON c.id = cc.customer_id WHERE cc.company_id = 1我试过在go-pg中做这样的事情:
var customers []*Customer
s.DB.Model(&customers).Relation("Companies", func(q *orm.Query) (*orm.Query, error) {
return q.Where("company_id = ?", companyID), nil
}).Select()https://stackoverflow.com/questions/41540051
复制相似问题