openwave 3.1.2
Previous topic Chapter index Next topic

View: vwhorecadochteraantallen

 

 

Schema

public

 

Owner

waveuser002

 

Descriptions

There is no description for view vwhorecadochteraantallen

 

Fields

Name

Data type

Description

tabel

varchar(20)

 

dnkeyhorecavergunningen

integer

 

aantal

bigint

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Definition

CREATE VIEW public.vwhorecadochteraantallen (
   tabel,
   dnkeyhorecavergunningen,
   aantal)
AS
       (        (        (        (        (        (        (        (
           (        (        (        (        (        (
SELECT 'tbtermbewstappen'::character varying(20) AS tabel,
                                                                                                                               a.dnkeyhorecavergunningen,
                                                                                                                               count(DISTINCT a.dnkeyorgprocedure + a.dninvoegnr) AS aantal
FROM tbtermijnbewstappen a
                                                                                                                         JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen
UNION
SELECT
'tbinbehandelingbij'::character varying(20) AS tabel,
                                                                                                                               a.dnkeyhorecavergunningen,
                                                                                                                               count(*) AS aantal
FROM tbinbehandelingbij a
                                                                                                                         JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen)
UNION
SELECT
'tbadviezen'::character varying(20) AS tabel,
                                                                                                                       a.dnkeyhorecavergunningen,
                                                                                                                       count(*) AS aantal
FROM tbadviezen a
                                                                                                                 JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen)
UNION
SELECT
'tbcorrespondentie'::character varying(20) AS tabel,
                                                                                                               a.dnkeyhorecavergunningen,
                                                                                                               count(*) AS aantal
FROM tbcorrespondentie a
                                                                                                         JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen)
UNION
SELECT
'tbcorrespbinnen'::character varying(20) AS tabel,
                                                                                                       a.dnkeyhorecavergunningen,
                                                                                                       count(*) AS aantal
FROM tbcorrespbinnen a
                                                                                                 JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen)
UNION
SELECT
'tbhorecacontactennn'::character varying(20) AS tabel,
                                                                                               a.dnkeyhorecavergunningen,
                                                                                               count(*) AS aantal
FROM tbhorecacontactennn a
                                                                                         JOIN tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen)
UNION
SELECT
'tbinspecties'::character varying(20) AS tabel,
                                                                                       a.dnkeyhorecavergunningen,
                                                                                       count(*) AS aantal
FROM tbinspecties a
                                                                             JOIN
                                                                                 tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen)
UNION
SELECT
'tblegesregels'::character varying(20) AS tabel,
                                                                           a.dnkeyhorecavergunningen,
                                                                           count(*)
                                                                               AS aantal
FROM tblegesregels a
                                                                     JOIN
                                                                         tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen)
UNION
SELECT
'tbhorexploitatie'::character varying(20) AS tabel,
                                                                   a.dnkeyhorecavergunningen,
                                                                   count(*) AS aantal
FROM tbhorexploitatie a
                                                             JOIN
                                                                 tbhorecavergunningen b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen)
UNION
SELECT
'tbhorterras'::character varying(20) AS tabel,
                                                           a.dnkeyhorecavergunningen,
                                                           count(*) AS aantal
FROM tbhorterras a
                                                     JOIN tbhorecavergunningen
                                                         b ON a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen)
UNION
SELECT
'tbhorspeelautomaten'::character varying(20) AS tabel,
                                                   a.dnkeyhorecavergunningen,
                                                   count(*) AS aantal
FROM tbhorspeelautomaten a
                                             JOIN tbhorecavergunningen b ON
                                                 a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen)
UNION
SELECT
'tbhorsluitingstijden'::character varying(20) AS tabel,
                                           a.dnkeyhorecavergunningen,
                                           count(*) AS aantal
FROM tbhorsluitingstijden a
                                     JOIN tbhorecavergunningen b ON
                                         a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen)
UNION
SELECT
'tbhorklachten'::character varying(20) AS tabel,
                                   a.dnkeyhorecavergunningen,
                                   count(*) AS aantal
FROM tbhorklachten a
                             JOIN tbhorecavergunningen b ON
                                 a.dnkeyhorecavergunningen = b.dnkey
GROUP BY a.dnkeyhorecavergunningen)
UNION
SELECT
'tbhorbeperkingen'::character varying(20) AS tabel,
                           a.dnkeyhorvergunning AS dnkeyhorecavergunningen,
                           count(*) AS aantal
FROM tbhorbeperkingen a
                     JOIN tbhorecavergunningen b ON a.dnkeyhorvergunning = b.dnkey
GROUP BY a.dnkeyhorvergunning)
UNION
SELECT
'tbhorlokaliteiten'::character varying(20) AS tabel,
                   a.dnkeyhorvergunning AS dnkeyhorecavergunningen,
                   count(*) AS aantal
FROM tbhorlokaliteiten a
             JOIN tbhorecavergunningen b ON a.dnkeyhorvergunning = b.dnkey
GROUP BY a.dnkeyhorvergunning)
UNION
SELECT
'tbhorontheffingen'::character varying(20) AS tabel,
           a.dnkeyhorvergunning AS dnkeyhorecavergunningen, count(*) AS aantal
FROM tbhorontheffingen a
     JOIN tbhorecavergunningen b ON a.dnkeyhorvergunning = b.dnkey
GROUP BY a.dnkeyhorvergunning;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-01-2013 17:28
Previous topic Chapter index Next topic