You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2007/07/13 10:08:05 UTC

[jira] Closed: (DERBY-2934) Trigger for data from two tables to one.

     [ https://issues.apache.org/jira/browse/DERBY-2934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Knut Anders Hatlen closed DERBY-2934.
-------------------------------------

    Resolution: Invalid

Please post these questions to derby-user@db.apache.org, not on JIRA.

> Trigger for data from two tables to one.
> ----------------------------------------
>
>                 Key: DERBY-2934
>                 URL: https://issues.apache.org/jira/browse/DERBY-2934
>             Project: Derby
>          Issue Type: Wish
>    Affects Versions: 10.2.2.0
>         Environment: Netbeans ide 5.5, linux
>            Reporter: Prakash
>
> i did create the below tables
> create table one (v_id int not null primary key generated always as identity(start with 1, increment  by 1), v_date date, cs_cr char (1) default 's' constraint cscr check (cs_cr in('s','r')), total decimal (5) )
> create table two (v_id int not null primary key generated always as identity(start with 1, increment  by 1), one_v_id inf foreign key references one(v_id), prd_code int foreign key references prd(prd_code), qty double, uom int foreign key references uom(uom_code), rate decimal (3) )
> create table three (v_id int not null primary key generated always as identity(start with 1, increment  by 1), one_v_id int, one_v_date, two_v_id int, prd_code int ,qty double)
> after create i want to know hw to create a single triger to insert/update [on change] values from "one", "two" to "three". 
> column in table three                                  value from table(column)
> v_id                                                                 should be auto generated.
> one_v_id                                                        one(v_id)
> one_v_date                                                   one(v_date)
> two_v_id                                                        two(v_id)
> prd_code                                                       two(prd_code)
> qty                                                                   two(qty)
> it could be found that the above table are without schema. if it is created with schema then hw to write a trigger.
> Prakash

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.