Hi ,
i have three tables
CREATE TABLE main_accounts (
main_id varchar(30) primary key,
main_name varchar(30) not null,
);
CREATE TABLE sub_accounts (
Sub_id varchar(30) primary key,
Sub_name varchar(30) not null,
Main_id varchar(30)
);
CREATE TABLE voucher (
voucher_id varchar(30) primary key,
voucher_date date not null,
amount numeric(11,2) not null,
debit_account_id varchar(30) not null references sub_accounts(Sub_id),
credit_account_id varchar(30) not null references sub_accounts(Sub_id)
);
I 'm trying to make trigger when button pressed execute quary and show all main accounts with summary of vouchers in for every main
i 'm using this trigger but it doesn't work
begin
select sum(voucher.AMOUNT_US)into :main_accounts.display_item6
from MAIN_ACCOUNTS inner join SUB_ACCOUNTS
on MAIN_ACCOUNTS.MAIN_ID=SUB_ACCOUNTS.MAIN_ID
inner join Voucher
on SUB_ACCOUNTS.SUB_ID=Voucher.DEBIT_ACCOUNT_ID
end;