>>You've got two columns that the system wants to call "obj_id" here.
>>Try something like
>> SELECT s.obj_id AS s_obj_id, ...
>
>That would have been elegant, but returns a 'syntax error at or near
>"s_obj_id"'. Hm...
Was just some minor syntax error. Works now - this is exactly what I wanted.
Thanks!
regards,
Christoph