如何从两个不同的列到单独的表上的同一列进行联接

这是一次只加入他们的方法：

SELECt   `logTime`,  `itemID`,  `typeName`,  `actorName`,  `stationName`,  `action`,  `passwordType`,  `quantity`,  `oldConfiguration`,  `newConfiguration` FROM  eve_container_audit LEFT JOIN  invTypesON  eve_container_audit.typeID = invTypes.typeID and  eve_container_audit.itemTypeID = invTypes.typeIDLEFT JOIN  staStationsON  eve_container_audit.locationID = staStations.stationID

如果您需要加入他们两次，请使用别名：

SELECt   `logTime`,  `itemID`,  `typeName`,  `actorName`,  `stationName`,  `action`,  `passwordType`,  `quantity`,  `oldConfiguration`,  `newConfiguration` FROM  eve_container_audit LEFT JOIN  invTypesON  eve_container_audit.typeID = invTypes.typeIDLEFT JOIN  invTypes invTypes2ON  eve_container_audit.itemTypeID = invTypes2.typeIDLEFT JOIN  staStationsON  eve_container_audit.locationID = staStations.stationID