Sql delete from with relation

# your select statement acctually works (and I don't know wich is your statement...).
# You must replace only
SELECT ...
# with
DELETE [table name or alias]
# and leave everything else the same.

# e.g:
DELETE cu FROM CustomUser cu 
left join RoleMapping on cu.id = RoleMapping.principalId 
WHERE RoleMapping.roleId = 1;

Source: stackoverflow.com

Similar codes

49 votes251 views6 answers
Get duplicate records in sql
SQL
0 vote168 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
0 vote196 views1 answer
Sqlcl format
SQL
0 vote170 views1 answer
MySQL error code 2068
SQL
1 vote170 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote178 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
1 vote169 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote167 views1 answer
Why we have to set the password for my sql server
SQL
1 vote209 views1 answer
Oracle grant select on schema
SQL
1 vote172 views3 answers
Epoch to datetime
SQL