MySQL在不同的列上连接两次相同的表而没有冲突

This is the query:

这是查询:

SELECT * FROM property_table AS property

INNER JOIN property_classification AS classifications
        ON property.classification_id = classifications.id

INNER JOIN property_classification AS classonrequest
        ON property.classonrequest_id = classonrequest.id

WHERE property.id=5000 LIMIT 1;
SELECT * FROM prop