On Nov 6, 2:54 pm, p...@impulzief.nl wrote:
> 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

What do you mean by "doesn't work?" It doesn't return what you think
it should? It gives a syntax error?

You have an extra = on this line:

WHEN person_right = 'Nick' = THEN person_left_id