您执行两次联接:
SELECT u.username, i1.path AS thumb, i2.path AS full
FROM users AS u
JOIN images AS i1 ON u.thumb_id = i1.image_id
JOIN images AS i2 ON u.fullimage_id = i2.image_id
同一张表的两个外键。如何编写此SELECT语句?
您执行两次联接:
SELECT u.username, i1.path AS thumb, i2.path AS full
FROM users AS u
JOIN images AS i1 ON u.thumb_id = i1.image_id
JOIN images AS i2 ON u.fullimage_id = i2.image_id