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 vote242 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote279 views1 answer
Sp help text in postgresql
SQL
0 vote218 views1 answer
Show all mongodb
SQL
0 vote240 views1 answer
On delete set default
SQL
1 vote243 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
1 vote242 views1 answer
SQL query to get all table records count from a database
SQL
9 votes219 views2 answers
Get first 3 letters in sql
SQL
0 vote222 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
3 votes229 views1 answer
Oracle rollback
SQL
2 votes248 views2 answers
Oracle create table if not exists
SQL