Dataprix es un portal de referencia sobre software y servicios IT para la empresa. Nuestra comunidad está integrada por profesionales y empresas IT interesados en compartir y difundir conocimiento y recursos sobre software y servicios de Tecnologías de la Información para las empresas.
Delete con inner join en SQL Server
- Lee más sobre Delete con inner join en SQL Server
- Inicie sesión para enviar comentarios
In SQL Server, to delete records from a table following a criterion that is related to another table in the database you can establish a join between the two tables in the same SQL Delete statement.
In SQL Server, to delete records from a table following a criterion that is related to another table in the database you can establish a join between the two tables in the same SQL Delete statement.
If we want to make a record delete using a join we must specify in the first line of the statement the table in which we want to apply the deletion of records, and in the next line the join of the tables we need, and the criterion indicated with a where..