Schema
public
Owner
waveuser002
Descriptions
There is no description for view vwmilklachten_behandelaar
Fields
Name | Data type | Description |
---|---|---|
dddatumklacht |
timestamp |
|
ddafgerond |
timestamp |
|
dnkeymilinrichtingen |
integer |
|
dvomschrklacht |
varchar(50) |
|
dvcodemedewerkers |
char(5) |
|
Rules
Name | Event | Instead | Condition | Description |
---|---|---|---|---|
_RETURN |
SELECT |
|
|
Definition
CREATE VIEW public.vwmilklachten_behandelaar (
dddatumklacht,
ddafgerond,
dnkeymilinrichtingen,
dvomschrklacht,
dvcodemedewerkers)
AS
SELECT tbklachten.dddatumklacht, tbklachten.ddafgerond,
tbklachten.dnkeymilinrichtingen,
tbklachtoverlast.dvomsoverlast AS dvomschrklacht,
tbklachten.dvcodemedewerkers
FROM tbklachten
JOIN tbklachtoverlast ON tbklachten.dnkeyklachtoverlast = tbklachtoverlast.dnkey
WHERE tbklachten.dddatumklacht IS NOT NULL AND tbklachten.ddafgerond IS NULL
AND (tbklachten.dnkeymilinrichtingen IN (
SELECT tbmilinrichtingen.dnkey
FROM tbmilinrichtingen
WHERE tbmilinrichtingen.ddblokkering IS NULL
));
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-01-2013 17:28 |
![]() ![]() ![]() |