--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

>
> DELETE FROM Child c
> WHERE EXISTS(
> SELECT 1 FROM Parent p
> WHERE p.F_CHILD_ID = c.F_ID AND p.F_FOO = 1)
>

Helen, could you explain how this query works? Is it standard SQL that
can be used across different database server?

I don't think understand exactly how this is parsed and how the
relation between Parent and Child is made here. The JOIN I understand,
even the Sub-Select I get, but I don't grok this one.

TIA,

R.