>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 ....)
Edward Pikman
Independent Consultant