The problem of duplicate query fields of linked table in ORM framework xorm of go language

when using xorm to query Join join tables, because both tables have Id fields and other fields, the official website needs to add anonymous references if they repeat:

clipboard.png

:

clipboard.png

GoogleGO

:

clipboard.png

clipboard.png

xorm

:

clipboard.png

removed the first structure and wrote two heavy fields.

I don"t know what better way to do it.

Mar.18,2021

I have encountered the same problem. How did you solve it in the end?

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e46b85-44bed.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e46b85-44bed.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?