记录 gorm 关联查询

db.GetConn().Model(&models.PurchaseContract{}).
Joins("left join purchase_contract_order_rel on purchase_contract.trans_code = purchase_contract_order_rel.contract_trans_code").
Where("entity_code = ? and order_trans_code != ? ", filter.EntityCode, filter.OrderTransCode).Select("purchase_contract.*")

posted @ 2022-01-14 17:34  Aqufish  阅读(116)  评论(0)    收藏  举报