"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