Hi,

> May I run a query like this:
>
> select
> info.*
> from
> tbl_contact con, sp_more_info(con.contact_id) info
> where
> con.value = ....

I guess this gives you problems.


Use this :

SELECT
info.*
FROM
tbl_contact con
LEFT JOIN sp_more_info(con.contact_id) info ON (1 = 1)
WHERE
con.value = .... and
info.somefield IS NOT NULL

or a sub-select

SELECT
(SELECT info.SomeField FROM sp_more_info(con.contact_id) info)
FROM
tbl_contact con
WHERE
con.value = ....

Regards,
Arno Brinkman