我在查询时遇到了麻烦。如果有问题,我想加表格。这是我正在使用的查询。我是这些案例陈述的新手,非常感谢您的帮助!$ J( G8 L9 O3 t2 H; U
SELECT conversation.c_id, conversation.user_one, conversation.user_two, users.name, users.lastName FROM `conversation` CASE WHEN conversation.user_one = THEN INNER JOIN `users` ON conversation.two = users.id WHEN conversation.user_two = THEN INNER JOIN `users` ON conversation.user_one = users.id END CASE WHERE `user_one` = 1 OR `user_two` = 3 _6 ?- N4 a" x+ @) S4 D9 `2 y 解决方案: