mysql的程序在哪里_MySQL在哪里

我读你不同意JOIN，但只是另一种方式来做..看到与朋友一起，如果它对你有用的话..

SELECT `timeline`.`action`, `timeline`.`data`, `timeline`.`tlupdate`,

u1.`id` AS ufrom_id, u1.`username` AS ufrom_username, u1.`firstname` AS ufrom_firstname, u1.`lastname` AS ufrom_lastname, u1.`picture` AS ufrom_picture,

u2.`id` AS uto_id, u2.`username` AS uto_username, u2.`firstname` AS uto_firstname, u2.`lastname` AS uto_lastname, u2.`picture` AS uto_picture,

m.`id` AS m_id, m.`name` AS m_name, m.`alternative_name` AS m_altname, m.`tiny_img` AS m_tiny, m.`normal_img` AS m_normal

FROM `timeline`

JOIN `users` u1 ON u1.`id` = `timeline`.`user_id_from`

JOIN `users` u2 ON u2.`id` = `timeline`.`user_id_to`

JOIN `friends` f on f.`idol_id`=u1.`id` or f.`idol_id`=u2.`id`

JOIN `movies` m ON m.`id` = `timeline`.`movie_id`;

更新：

当你使用内部连接你也可以这样做，以避免完整的结果集的条件。

JOIN `friends` f on ((f.`idol_id`=u1.`id` or f.`idol_id`=u2.`id`) and f.idol_id = ?)

您可以使用DISTINCT或使用GROUP BY获得唯一的结果。