>What is a primary key you can identify records by?
>
>Delete from mytable where primarykey in (Select primarykey from listmemberfield inner join listfield on ListMemberField.NoListField=ListField.Numero
>WHERE ListField.NoList=143
> )

Frank's syntax is the one I was looking for. I just forgot to include an additional reference to the table at startup.