--- In firebird-support@yahoogroups.com, Svein Erling Tysvaer
<svein.erling.tysvaer@...> wrote:

> select <fields>
> from product_participant pp
> where exists(select * from participant_name pn
> where pp.participantid = pn.participantid
> and pn.name = :MyName)

That worked, thanks :-)