Datadictionary OpenWave 3.1.5
Previous topic Chapter index Next topic

View: vwaantaltoestemmingen

 

 

Schema

public

 

Owner

waveuser002

 

Descriptions

There is no description for view vwaantaltoestemmingen

 

Fields

Name

Data type

Description

dnkeyomgvergunningen

integer

 

dnaantal

bigint

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Definition

CREATE VIEW public.vwaantaltoestemmingen (
   dnkeyomgvergunningen,
   dnaantal)
AS
SELECT
a.dnkeyomgvergunningen, count(*) AS dnaantal
FROM tbtoestemmingen a
  JOIN tbomgvergunning b ON a.dnkeyomgvergunningen = b.dnkey
GROUP BY a.dnkeyomgvergunningen;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 15-5-2014 16:11
Previous topic Chapter index Next topic