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'
Related Posts:
- T-SQL split string
- How to delete duplicate rows in SQL Server?
- Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
- Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
- How can I get column names from a table in SQL Server?
- sql query to return differences between two tables
- How to select the last record of a table in SQL?
- Inserting multiple rows in a single SQL query? [duplicate]
- SQL query to get the employee name and their manager name from the same table
- Rename column SQL Server 2008
- Efficiently convert rows to columns in sql server
- The SQL OVER() clause – when and why is it useful?
- Update multiple columns in SQL
- SQL Query with NOT LIKE IN
- SQL Server IF EXISTS THEN 1 ELSE 2
- T-SQL split string based on delimiter
- SQL Query with SUM with Group By
- How do I perform an IF…THEN in an SQL SELECT?
- SQL update from one Table to another based on a ID match
- An attempt was made to access a socket in a way forbidden by its access permissions
- How to drop all tables from a database with one SQL query?
- SQL Server : Arithmetic overflow error converting expression to data type int
- How to calculate percentage with a SQL statement
- Difference between JOIN and INNER JOIN
- Query comparing dates in SQL
- What is the meaning of the prefix N in T-SQL statements and when should I use it?
- Query error with ambiguous column name in SQL
- How to drop all tables from a database with one SQL query?
- How to find sum of multiple columns in a table in SQL Server 2005?
- SQL Server Insert if not exists
- CREATE TABLE IF NOT EXISTS equivalent in SQL Server
- SQL Server: Invalid Column Name
- How to group by month from Date field using sql
- Is there a combination of “LIKE” and “IN” in SQL?
- Search text in stored procedure in SQL Server
- MS SQL compare dates?
- MS SQL compare dates?
- How do I fix ‘Invalid character value for cast specification’ on a date column in flat file?
- Determine ROW that caused “unexpected end of file” error in BULK INSERT?
- Determine ROW that caused “unexpected end of file” error in BULK INSERT?
- What is the maximum characters for the NVARCHAR(MAX)?
- Using RegEx in SQL Server
- Microsoft OLE DB Provider for SQL Server error ‘80004005’
- Bulk load data conversion error (truncation)
- How to format a numeric column as phone number in SQL
- SQL – WHERE (X, Y) IN (A, B)
- SQL: IF clause within WHERE clause
- Backup a single table with its data from a database in sql server 2008
- How can I group by date time column without taking time into consideration
- SQL- Ignore case while searching for a string
- Comma separated results in SQL
- SHOWPLAN permission denied in database ‘tempdb’. in sql server 2008
- Filter data based on date in sql
- Varchar invalid for Sum operator
- Using Excel VBA to run SQL query
- What is tableName.* in SQL
- What is the difference between “INNER JOIN” and “OUTER JOIN”?
- What do Clustered and Non-Clustered index actually mean?
- Conversion failed when converting date and/or time from character string while inserting datetime
- SQL query to select dates between two dates
- What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
- NOT IN vs NOT EXISTS
- Must declare the scalar variable
- How do I escape a single quote in SQL Server?
- Data source name not found, and no default driver specified
- Optimistic vs. Pessimistic locking
- Column name or number of supplied values does not match table definition
- Can a foreign key be NULL and/or duplicate?
- How do I do multiple CASE WHEN conditions using SQL Server 2008?
- When to use SELECT … FOR UPDATE?
- The target principal name is incorrect. Cannot generate SSPI context
- BCP error “Unable to open BCP host data-file”
- Delete all the records
- “CASE” statement within “WHERE” clause in SQL Server 2008
- What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
- SQL Server WITH statement
- DateTime2 vs DateTime in SQL Server
- Difference between numeric, float and decimal in SQL Server
- SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904)
- What is the equivalent of ‘describe table’ in SQL Server?
- How do I query for all dates greater than a certain date in SQL Server?
- String or binary data would be truncated. The statement has been terminated
- Add a column with a default value to an existing table in SQL Server
- Error converting data type varchar to float
- ClassNotFoundException – com.microsoft.jdbc.sqlserver.SQLServerDriver
- The SELECT permission was denied on the object ‘Users’, database ‘XXX’, schema ‘dbo’
- How do you open an SDF file (SQL Server Compact Edition)?
- Conversion failed when converting the varchar value ‘simple, ‘ to data type int
- Trouble Connecting to sql server Login failed. “The login is from an untrusted domain and cannot be used with Windows authentication”
- ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine.
- Update statement with inner join on Oracle
- How do I format a number with commas in T-SQL?
- Can I use multiple “with”?
- Incorrect syntax near ”
- To add server using sp_addlinkedserver
- How to connect to a local database in SQL Server Management Studio?
- Arithmetic overflow error converting varchar to data type numeric. ’10’ <= 9.00
- What are named pipes?
- INSERT VALUES WHERE NOT EXISTS
- How to implement LIMIT with SQL Server? [duplicate]