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

5 votes349 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote340 views1 answer
How to count with except in psql
SQL
0 vote410 views1 answer
Oracle pl/sql check if file exists
SQL
1 vote361 views1 answer
Mysql tables max count
SQL
0 vote367 views1 answer
Sql reverse order of results
SQL
0 vote405 views1 answer
How to set up an anonymous function to variable in swift
SQL
1 vote336 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote354 views1 answer
How to set all the min and sec data to zero in sql server
SQL
52 votes619 views6 answers
Rename column sql
SQL
2 votes376 views1 answer
Mariadb json select
SQL