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

-1 vote271 views2 answers
Datetime sql server week
SQL
5 votes318 views1 answer
How to check port number for postgresql
SQL
0 vote277 views1 answer
How to check oracle index table
SQL
8 votes338 views1 answer
Sql remove leading spaces
SQL
0 vote321 views1 answer
Oracle c# multiple update sql
SQL
2 votes324 views1 answer
Sql count having
SQL
1 vote336 views1 answer
Postgres power
SQL
1 vote300 views1 answer
Oracle current sequence value
SQL
0 vote335 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
2 votes318 views1 answer
Drop table purge
SQL