You need to specify what table you are deleting from. Here is a version with an alias:
DELETE w
FROM WorkRecord2 w
INNER JOIN Employee e
ON EmployeeRun=EmployeeNo
WHERE Company = '1' AND Date="2013-05-06"
More Related Contents:
- Is having an ‘OR’ in an INNER JOIN condition a bad idea?
- Is it possible to write single query on two table which are not connected to each other?
- sql server 2008 management studio not checking the syntax of my query
- Split function equivalent in T-SQL?
- Querying data by joining two tables in two database on different servers
- Where value in column containing comma delimited values
- How to find all connected subgraphs of an undirected graph
- How to use table variable in a dynamic sql statement?
- SQL query to split column data into rows
- Common Table Expression, why semicolon?
- T-SQL split string based on delimiter
- Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
- Create Trigger to log SQL that affected table?
- How do I find duplicates across multiple columns?
- Transfer data from one database to another database
- How to find third or nᵗʰ maximum salary from salary table?
- SQL “between” not inclusive
- How to efficiently delete rows while NOT using Truncate Table in a 500,000+ rows table
- Can I set ignore_dup_key on for a primary key?
- Selecting first row per group
- Using PIVOT in SQL Server 2008
- sql group by only rows which are in sequence
- Function in SQL Server 2008 similar to GREATEST in mysql?
- store arabic in SQL database
- How to retrieve field names from temporary table (SQL Server 2008)
- How to combine results of two queries into a single dataset
- When using GETDATE() in many places, is it better to use a variable?
- Executing SQL Server Agent Job from a stored procedure and returning job result
- How to execute a stored procedure inside a select query
- Using CASE Statement inside IN Clause