Both tables in the join query have id auto-increment fields. After querying, which table's id will be displayed?

Question

Join query Both tables have id auto-increment fields. After querying, which table's id will be displayed?

The id fields I output all become integers 1. How to solve this?

Answer 1

You can also answer it yourself

Answer 2

Answer it yourself.

Use field('a.id') to extract the desired ID. Of course, if you want other fields, you can add the fields you want after the parentheses after the field, but you cannot enter the alias of the table. The alias of the table I used.