May 2018 - Steve Stedman

Combining many SQL files into one

I come across the need occasionally to deploy a set of sql files that are all checked into source control in different files with a… Read More »Combining many SQL files into one

This confused me for a few minutes today and I wanted to share to help avoid further confusion.

The specific code was this:


DELETE t2
FROM [dbo].[Table1] t1
INNER JOIN [dbo].[Table2] t2 on t1.favColor = t2.id;

Names have been changed to protect the innocent.

In the above delete statement which table will have rows deleted from it?

A: Table1

B: Table2

C: Both Table1 and Table2

D: Neither Table1 and Table2