DELETE TableA FROM TableA a INNER JOIN TableB b ON b.Bid = a.Bid AND [my filter condition]
should work
Related Posts:
- LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- SQL Server: Difference between PARTITION BY and GROUP BY
- Function to Calculate Median in SQL Server
- Function to Calculate Median in SQL Server
- What is the use of GO in SQL Server Management Studio & Transact SQL?
- Delete all the records
- In SQL Server, what does “SET ANSI_NULLS ON” mean?
- Sql Server string to date conversion
- Check if table exists in SQL Server
- SQL Server String or binary data would be truncated
- Format number as percent in MS SQL Server
- How to truncate string using SQL server
- Pad a string with leading zeros so it’s 3 characters long in SQL Server 2008
- What is the difference between “INNER JOIN” and “OUTER JOIN”?
- What is the difference between “INNER JOIN” and “OUTER JOIN”?
- Selecting COUNT(*) with DISTINCT
- What is a stored procedure?
- Inserting multiple rows in a single SQL query? [duplicate]
- How to drop a table if it exists?
- SQL Inner-join with 3 tables?
- Self Join to get employee manager name
- SQL query to select dates between two dates
- What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
- When should I use CROSS APPLY over INNER JOIN?
- How can I do an UPDATE statement with JOIN in SQL Server?
- T-SQL split string
- Join/Where with LINQ and Lambda
- How can I do a FULL OUTER JOIN in MySQL?
- SQL Query with NOT LIKE IN
- How do I escape a single quote in SQL Server?
- pandas: merge (join) two data frames on multiple columns
- T-SQL split string based on delimiter
- How do I perform an IF…THEN in an SQL SELECT?
- How do I escape a single quote in SQL Server?
- SQL update from one Table to another based on a ID match
- Each GROUP BY expression must contain at least one column that is not an outer reference
- SQL Server : Arithmetic overflow error converting expression to data type int
- LEFT OUTER JOIN in LINQ
- How to calculate percentage with a SQL statement
- Column name or number of supplied values does not match table definition
- SQL Server FOR EACH Loop
- Difference between JOIN and INNER JOIN
- What is the meaning of the prefix N in T-SQL statements and when should I use it?
- What is the difference between JOIN and UNION?
- MySQL Multiple Joins in one query?
- SQL join on multiple columns in same tables
- Query error with ambiguous column name in SQL
- Operand type clash: int is incompatible with date + The INSERT statement conflicted with the FOREIGN KEY constraint
- 1052: Column ‘id’ in field list is ambiguous
- Keeping it simple and how to do multiple CTE in a query
- 1052: Column ‘id’ in field list is ambiguous
- Find all tables containing column with specified name – MS SQL Server
- DateTime2 vs DateTime in SQL Server
- SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
- How can I get column names from a table in SQL Server?
- Is there a combination of “LIKE” and “IN” in SQL?
- Pandas join issue: columns overlap but no suffix specified
- How to get a date in YYYY-MM-DD format from a TSQL datetime field?
- PadLeft function in T-SQL
- What is the equivalent of ‘describe table’ in SQL Server?
- Error converting data type varchar to float
- What is semi-join in database?
- How to join on multiple columns in Pyspark?
- MS SQL compare dates?
- MS SQL compare dates?
- I want to use CASE statement to update some records in sql server 2005
- What represents a double in sql server?
- Get size of all tables in database
- Using RegEx in SQL Server
- Conversion failed when converting the varchar value ‘simple, ‘ to data type int
- Must declare the scalar variable
- SELECT DISTINCT on one column
- Exclude a column using SELECT * [except columnA] FROM tableA?
- TSQL PIVOT MULTIPLE COLUMNS
- SQL version of VLOOKUP
- How to format a numeric column as phone number in SQL
- Equivalent of Oracle’s RowID in SQL Server
- How do I format a number with commas in T-SQL?
- Get current year in TSQL
- SQL: IF clause within WHERE clause
- Can I use multiple “with”?
- SQL Server dynamic PIVOT query?
- How to write a foreach in SQL Server?
- Error converting data type varchar
- Join vs. sub-query
- Conditional JOIN Statement SQL Server
- Temporary table in SQL server causing ‘ There is already an object named’ error
- I want to use CASE statement to update some records in sql server 2005
- To add server using sp_addlinkedserver
- How to calculate age (in years) based on Date of Birth and getDate()
- ORDER BY items must appear in the select list if SELECT DISTINCT is specified
- Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
- How can I group by date time column without taking time into consideration
- Arithmetic overflow error converting varchar to data type numeric. ’10’ <= 9.00
- Comma separated results in SQL
- SUM OVER PARTITION BY
- Update query using Subquery in Sql Server
- Varchar invalid for Sum operator
- How to count instances of character in SQL Column