Datadictionary OpenWave 3.1.11
Previous topic Chapter index Next topic

View: vwomgheeftadviezen

 

 

Schema

public

 

Owner

waveuser005

 

Descriptions

There is no description for view vwomgheeftadviezen

 

Fields

Name

Data type

Description

dnkeyomgheeftadv

integer

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Definition

CREATE VIEW public.vwomgheeftadviezen (
   dnkeyomgheeftadv)
AS
SELECT DISTINCT
a.dnkeyomgvergunningen AS dnkeyomgheeftadv
FROM tbomgvergunning b
  JOIN tbadviezen a ON b.dnkey = a.dnkeyomgvergunningen
WHERE b.ddblokkering IS NULL;

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