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.