Delete from inner join sql

    DELETE WorkRecord2 
      FROM WorkRecord2 
INNER JOIN Employee 
        ON EmployeeRun=EmployeeNo
     WHERE Company = '1' 
       AND Date = '2013-05-06';

Source: stackoverflow.com

Similar codes

0 vote214 views1 answer
Sql server remove primary key without dropping table
SQL
-1 vote214 views1 answer
Io
SQL
0 vote221 views1 answer
Createdb with postgresql on ubuntu
SQL
2 votes217 views1 answer
Oracle trace session
SQL
2 votes208 views1 answer
How to select first row of database sql
SQL
0 vote224 views1 answer
Group by two columns postgres
SQL
0 vote226 views1 answer
Alter fedora mysql 8.0 user
SQL
-1 vote201 views1 answer
How to use update trigger in sql
SQL
0 vote224 views1 answer
Oracle list datafiles
SQL
1 vote224 views1 answer
Postgresql float 2 decimal places
SQL