View vwaantlegespertoest

Datadictionary OpenWave 3.1.11

View: vwaantlegespertoest

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwaantlegespertoest

Fields

Name	Data type	Description
dnaantallegesregels	bigint
dnkeytoestemmingen	integer
dnkeyomgvergunningen	integer

Rules

Name	Event	Instead	Condition	Description
_RETURN	SELECT

Definition

CREATE VIEW public.vwaantlegespertoest ( dnaantallegesregels, dnkeytoestemmingen, dnkeyomgvergunningen) AS SELECT sum(1) AS dnaantallegesregels, a.dnkeytoestemmingen, a.dnkeyomgvergunningen FROM tblegesregels a WHERE a.dnkeytoestemmingen IS NOT NULL GROUP BY a.dnkeytoestemmingen, a.dnkeyomgvergunningen;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50