>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
>
>
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
)
>This gives 22 records.
>
>I basically need to delete those 22 records by adjusting the SQL command for a delete syntax.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________