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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
