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 12-9-2013 10:19 |
![]() ![]() ![]() |