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?