SANEO PARA ELIMINAR FAMILIAS QUE NO TIENEN ESTUDIANTES

DELETE FROM sima.familiar_x_familia WHERE cod_familiar IN ((SELECT cod_familiar FROM sima.familiar_x_familia WHERE cod_familiar NOT IN((SELECT cod_familia FROM sima.detalle_alumno))));
Elimino a familiares que no tienen estudiantes asignados

1 Response

SSS

Write a comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.