And also optimizable (I think, at least for joining)
>Thanks
>Thats even easier!
>>>Hi to all
>>>I have 2 tables in a relation on one field. I would now want to select records in the parent table where there are no corresponding records in the child table.
>>>
>>>Any easy way to do this?
>>>
>>>Thanks in advance.
>>>
>>>Willie
>>
>>
>>SELECT ParentTable.*;
>> FROM ParentTable;
>> LEFT JOIN ChildTable ON ParentTable.Id = ChildTable.Id;
>> WHERE ISNULL(ChildTable.Id);
>>INTO CURSOR crsParentWOChild
>>
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.