>I have a need to delete from a inner join.
>
>This is the original SQL command:
>
>

>SELECT * FROM ListMemberField
> INNER JOIN ListField ON ListMemberField.NoListField=ListField.Numero
> WHERE ListField.NoList=143
>

>
>This gives 22 records.
>
>I basically need to delete those 22 records by adjusting the SQL command for a delete syntax.

should be something like (off the top of my head):

DELETE ListMemberField
FROM ListMemberField INNER JOIN ListField ON ListMemberField.NoListField=ListField.Numero
WHERE ListField.NoList=143