Dear All,

Could anybody help here?
I have two tables (meetings and persons).
The persons meet each other and their person_id will be stored in
meetings. I do not know what person is standing left or right
(random).

Now I want to see who Nick met yesterday. All personal information is
in table persons so I want to use INNER JOIN to collect the right
information. But what I write down below doesn't work

How could the following be done:

SELECT *,
CASE
WHEN person_left = 'Nick' THEN person_right_id
WHEN person_right = 'Nick' = THEN person_left_id
END AS person_id_to_get_more_info
FROM meetings INNER JOIN persons ON
persons.person_id=person_id_to_get_more_info


Anybody have a suggestion?


Pim Zeekoers