sql - SQL中的错误(SELECT和LEFT Join)如何给第一个表id？

Question

我有 sql 选择:

SELECT * 
FROM `fclients` AS F 
LEFT JOIN `fclients_sequens` AS FS ON F.category = FS.category 
ORDER by FS.num

我得到了结果:

然后，对于第一个表中给定的 id，我进行 sql 查询:

SELECT *, fclients.id as fclientsID 
FROM `fclients` AS F 
LEFT JOIN `fclients_sequens` AS FS ON F.category = FS.category 
ORDER by FS.num

我得到一个错误:

#1054 - Unknown column 'fclients.id' in 'field list'

请告诉我如何给 id 第一列 (id=37)？

Answer 1

引用列ID时需要使用别名F

SELECT *, F.id...