gorm

1
2

db.Table("go_service_info").Select("go_service_info.serviceId as service_id, go_service_info.serviceName as service_name, go_system_info.systemId as system_id, go_system_info.systemName as system_name").Joins("left join go_system_info on go_service_info.systemId = go_system_info.systemId").Scan(&results)

1
2
3
4
5
6

db.Table("table0").
Select("table0.field0, table0.field1").
Joins("join table1 on table0.field0=table1.field0").
Where("table0.field0=? and table1.field1=?", foo, bar).
First(&obj)