pim@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

With what you told us it is not possible to get the result that you want as
there appears to be no way to tell the date of the meetings.

This is actually a job that PROLOG excels at.