Sql query to remove from two tables at once, SQL Server

To avoid such queries you should configure the relationship with the cascading deletion rule, so when you delete a query type the database engine will only take care of deleting the associated queries,

In the image if and I place the cascading relationship, when I delete a workshop, all orders belonging to that workshop will be deleted.

I know it's not the answer you want since you're explicitly asking by query, but it is a valid path to take.

I know it's a little late and you've probably figured it out, anyway I'll answer if anyone else does:)

In SQL SERVER - is not possible delete from two tables at the same time using the sentence DELETE (I understand that in MySQL if you can), at least until SQL SERVER 2016: according to the documentation (https://msdn.microsoft.com/en-us/library/ms189835.aspx) you can only specify a table of destination for removal.

If you can't set up a cascading delete rule on the Foreign Key as bloodday indicates (I guess it has one), the only way I see would be to delete queries that have that type first and then the type itself, this in two separate operations:

DELETE Ad_Consultas 
WHERE Sec_TipoConsulta= 121;

DELETE Ad_TipoConsulta
WHERE Sec_TipoConsulta= 121;

And if there is a possibility that one of the deletions will fail, both must be executed on the same transaction (with proper error handling)to prevent it from being half done (e.g. delete queries, but not the type)

If you want to remove from the two tables in the same query you should use a INNER JOIN , for example:

DELETE Ad_TipoConsulta, Ad_Consultas FROM Ad_TipoConsulta INNER JOIN Ad_Consultas 

I think one way to do this is to first delete the table with the foreign key and then delete the normal table, for example something like this:

DELETE 
  FROM Ad_TipoConsulta 
WHERE Ad_TipoConsulta.Sec_TipoConsulta = 

(SELECT Ad_Consultas.Sec_TipoConsulta 
  FROM Ad_Consultas 
WHERE Ad_Consultas.Sec_TipoConsulta = 121 
--Aqui pueden ir más validaciones 
)

That would do is remove all rows of "Ad_consult" that have in their foreign key the value of the Select Ad_consults.Sec_consult type

Then you delete Ad_consults if it is also what you want, doing something like

DELETE 
       FROM Ad_Consultas
WHERE Ad_Consultas.Sec_TipoConsulta = 121

I work something similar when the SELECT it brought only one row, I don't know if it doesn't work if it's more than one