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.
