Hello Arno,

Actually I tried another one:

select
info.*
from
tbl_contact con LEFT OUTER JOIN sp_more_info(con.contact_id) info
where
con.value = ....

And it works ??? I can not understand why. My guess is this is not
a correct query.

The intention of this query is that I fetch Id-s from one table and
whant to read moreinfo about this Id's. Can you suggest some better
way to do this, maybe using view or something

--
Best regards,
Alexander mailto:saho@...