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

See the SELECT - SQL help.

There are some clauses to add to the SELECT like INNER, RIGHT, etc.