选择特定于表的列

Question

我在多个不同的表中有相同名称的列。我使用JavaScript发送一个包含字段的对象，Node.js包创建一个具有名称的数组，因此，如果两个列的名称相同，则最后一个列的值似乎会放在数组中。

我有个疑问

SELECT * 
FROM FACTURATION AS F 
LEFT JOIN ENREGISTREMENT AS E ON F.Enregistrement=E.Numero 
LEFT JOIN RESTITUTION AS R ON F.Restitution=R.Numero 
LEFT JOIN RESERVATION AS X ON F.Numero=X.Facturation 
LEFT JOIN CLIENT AS C ON X.Numero_Client=C.Numero

返回我的值。知道Select *不是一个好的实践，我把它改为

SELECT Nom, Caution, Kilometrage 
FROM FACTURATION AS F 
LEFT JOIN ENREGISTREMENT AS E ON F.Enregistrement=E.Numero 
LEFT JOIN RESTITUTION AS R ON F.Restitution=R.Numero 
LEFT JOIN RESERVATION AS X ON F.Numero=X.Facturation 
LEFT JOIN CLIENT AS C ON X.Numero_Client=C.Numero

而且效果也很好。但是，我需要区分这两列和不同的表。我试过了

SELECT CLIENT.Nom, ENREGISTREMENT.Caution, ENREGISTREMENT.Kilometrage 
FROM FACTURATION AS F 
LEFT JOIN ENREGISTREMENT AS E ON F.Enregistrement=E.Numero 
LEFT JOIN RESTITUTION AS R ON F.Restitution=R.Numero 
LEFT JOIN RESERVATION AS X ON F.Numero=X.Facturation 
LEFT JOIN CLIENT AS C ON X.Numero_Client=C.Numero

它什么也不回。即使我只选择CLIENT.Nom，它在选择Nom时也不起作用。我使用来自Node Package Manager的Node Package Manager包

Answer 1

不用表名，您可以为列名使用别名。

SELECT C.Nom, E.Caution, E.Kilometrage 
FROM FACTURATION AS F 
LEFT JOIN ENREGISTREMENT AS E ON F.Enregistrement=E.Numero 
LEFT JOIN RESTITUTION AS R ON F.Restitution=R.Numero 
LEFT JOIN RESERVATION AS X ON F.Numero=X.Facturation 
LEFT JOIN CLIENT AS C ON X.Numero_Client=C.Numero