>I want to use the command join in the select of the SQL, but it doesn't exist.
>
>Any ideas ?
>
>I want that the select return an elemnet when the key that connect a parent and other
>table is empty.

You can use JOIN for version 5. For previous version you have to write it manually using UNION Select .... Where key NOT IN (Select ....)