Creo esto te resultaria aunque para un id_paciente SELECT top(1) creditos.id_detalle_venta AS Venta, creditos.id_credito AS Crédito, creditos.monto AS Total, creditos.saldo AS Saldo FROM creditos INNER JOIN detalle_venta ON creditos.id_detalle_venta =...

Que bueno gracias

Create table pagos ( alumno int not null primary key, empleado int not null, beca varchar(2), pago money, folio int ); Create Trigger pago_beca on pagos for insert as Begin declare @al int, @beca varchar(2) Select @al = alumno...

create trigger Yaa on dbo.Pago for insert as begin declare @dec char, @cod int select @dec= beca, @cod = id_pago from inserted if(@dec='Si') begin update dbo.Pago set pago=1200 where id_pago = @cod end else begin raiserror('Error no se pudieron concretar las...