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

0 vote311 views1 answer
Delet all record statment sql
SQL
0 vote201 views1 answer
Install mysql 8 linux
SQL
4 votes203 views1 answer
Wildcard in sql
SQL
0 vote215 views1 answer
Get substract count sql
SQL
0 vote224 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
15 votes202 views2 answers
How to drop database name in postgresql
SQL
0 vote223 views1 answer
Postgres clear table
SQL
0 vote196 views1 answer
Postgresql get current user name
SQL
1 vote217 views2 answers
Oracle list partitioned tables
SQL
0 vote218 views2 answers
Sql query for getting details by id
SQL