Files

4 lines
223 B
SQL

-SQL-
SELECT Behandlungsbeginn, Behandlungsende, Total, dbo.get_name(Nrpatient) AS Patient, dbo.get_name(Nrbehandler) AS Behandler, Status, aktiv
FROM dbo.Behandlu
WHERE (Status = 4) AND (aktiv = 1)