Hi,

> 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

I don't see anything wrong with using a LEFT JOIN then !
The left join ensures that the SP is 'executed' after tbl_contact, so
contact_id holds a value.

Regards,
Arno