Re: two foreign keys

"Josh Berkus" <josh@agliodbs.com> writes:
> SELECT session_id, session_name, op_start.operator_name,
>  op_end.operator_name
> FROM sessions
>    JOIN operators op_start ON sessions.operator_start_id =
>  op_start.operator_id
>    JOIN operators op_end ON sessions.operator_end_id =
>  op_start.operator_id;

I think you meant "ON sessions.operator_end_id = op_end.operator_id"
at the end there.  Otherwise a fine example...

            regards, tom lane