>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.

Well that's ok bu it is an OUTER join. If I use LEFT JOIN I get
only one result.

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