Schema
public
Owner
waveuser002
Descriptions
There is no description for view vwmilinrhoofdsbi
Fields
Name | Data type | Description |
---|---|---|
dnkeymilinrichtingen |
integer |
|
dlhoofdsbi |
char(1) |
|
dnkeymilsbi |
integer |
|
dvsbinummer |
varchar(11) |
|
dvsbilijst |
varchar(4) |
|
dvsbioms |
varchar(100) |
|
dnkeymilcodesbi |
integer |
|
Rules
Name | Event | Instead | Condition | Description |
---|---|---|---|---|
_RETURN |
SELECT |
|
|
Definition
CREATE VIEW public.vwmilinrhoofdsbi (
dnkeymilinrichtingen,
dlhoofdsbi,
dnkeymilsbi,
dvsbinummer,
dvsbilijst,
dvsbioms,
dnkeymilcodesbi)
AS
SELECT max(tbmilsbi.dnkeymilinrichtingen) AS dnkeymilinrichtingen,
max(tbmilsbi.dlhoofdsbi)::character(1) AS dlhoofdsbi,
max(tbmilsbi.dnkey) AS dnkeymilsbi,
max(tbmilcodesbi.dvsbinummer::text)::character varying(11) AS dvsbinummer,
max(tbmilcodesbi.dvsbilijst::text)::character varying(4) AS dvsbilijst,
max(tbmilcodesbi.dvsbioms::text)::character varying(100) AS dvsbioms,
max(tbmilcodesbi.dnkey) AS dnkeymilcodesbi
FROM tbmilsbi
JOIN tbmilcodesbi ON tbmilsbi.dnkeymilcodesbi = tbmilcodesbi.dnkey
WHERE tbmilsbi.dlhoofdsbi = 'T'::bpchar
GROUP BY tbmilsbi.dnkeymilinrichtingen;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 17-1-2014 15:30 |
![]() ![]() ![]() |