MySQL - 没有重复列的左连接

Question

我尝试使用的一些连接语句存在问题。我有两个表需要连接，两个表都包含所有信息。它们如下。

INSTITUTION
IName | ALocation_ID | IPicture

ADDRESS
ALocation_ID | AStreet | AZip | ...(other relevant fields)

我一直在尝试使用:

CREATE VIEW InstitutionView
AS SELECT * FROM INSTITUTION 
LEFT JOIN ADDRESS 
ON INSTITUTION.ALocation_ID=ADDRESS.ALocation_ID;

但是我收到的错误说明了有关重复列的信息。我做错了什么？

Answer 1

您必须单独选择列。希望这对您有所帮助。

CREATE VIEW InstitutionView
AS 
SELECT address.id,address.iname,address.alocation_id,ipicture,institution.astreet,institution.azip
FROM INSTITUTION 
LEFT JOIN ADDRESS 
ON INSTITUTION.ALocation_ID=ADDRESS.ALocation_ID;