SQL Delete Join Statement

josephroddy · **Joined:** December 25th, 2004, 3:31 pm **Posts:** 178

Hello,

Having problems using SQL delete statement to delete using Join.

The SQL Select Statement works:

Two tables Rec & Groups

Code:

SELECT Rec.Name, Groups.GroupName FROM Rec, Groups WHERE Rec.UserGroup = Groups.ID AND Groups.GroupName = 'MyGroup';

This works great and return the names from Rec who's UserGroup equals the GroupID from table Groups. My problem is deleting this. I have tried delete methods found at:

http://www.java2s.com/Code/SQL/Join/Delete-From-Join.htm
http://www.elevatesoft.com/dbisam4d5_delete_statement.htm

But I keep getting an SQL error in Opus:

Quote:

Specify the table containing the records you want to delete.

Any suggestions?

Digital Workshop