db.Joins("Company", db.Where(&Company{Alive: true})).Find(&users)
的输出结果是 select ... from sometable Company
查了不少文章，chatgpt也试试了
有效果的就是 db.Joins("LEFT JOIN Company ON ...")
这个好呆
1、Company用字符串输入本身就很呆，不是应该用模型去解析表名吗？
2、ON里的字段不是应该用.Where()方法来拼吗？用字符串来写，还不如.Raw()呢！！！
Comment From: github-actions[bot]
The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨
Comment From: zzhaoh
https://gorm.io/zh_CN/docs/preload.html 如果希望使用gorm的join自动拼接，需要你的相关表结构体有关联关系
Comment From: github-actions[bot]
The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨
Comment From: kuangshp
db.Joins("Company", db.Where(&Company{Alive: true})).Find(&users)的输出结果是select ... from sometable Company查了不少文章，chatgpt也试试了 有效果的就是
db.Joins("LEFT JOIN Company ON ...")这个好呆 1、Company用字符串输入本身就很呆，不是应该用模型去解析表名吗？ 2、ON里的字段不是应该用.Where()方法来拼吗？用字符串来写，还不如.Raw()呢！！！
你也可以用gen来实现，我代码里面就直接这样干过去
Comment From: github-actions[bot]
The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨