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?
You can also answer it yourself
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.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
You can also answer it yourself
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.