CREATE TABLE TabapousiesOK
( Id int ,
Epitheto varchar(20) ,
Adik int ,
ApousiaDate date,
dik varchar(4)
)
CREATE TABLE Tabapousiesdik
( Id int ,
Epitheto varchar(20) NOT NULL,
Adik int ,
ApousiaDate date,
dik varchar(4)
)
CREATE VIEW ViewSumApousies AS
select * from tabapousiesok
union
select * from tabapousiesdik
SELECT Id, Epitheto,sum(adik) as dikaiologimenes FROM Tabapousiesdik
group by id,epitheto;
SELECT Id, Epitheto,sum(adik) as dikaiologimenes FROM TabapousiesOk
group by id,epitheto;
CREATE VIEW ViewSumApousies AS
SELECT Id, Epitheto,sum(adik) as Adikaiologites FROM TabapousiesOk
group by id,epitheto;
CREATE VIEW ViewTabapousiesdik AS
SELECT Id, Epitheto,sum(adik) as dikaiologimenes FROM Tabapousiesdik
group by id,epitheto;
CREATE VIEW ViewTabapousiesdikKid AS
SELECT Id, Epitheto,sum(adik) as dikaiologimenes FROM Tabapousiesdik
where dik=’kid’ group by id,epitheto;
CREATE VIEW ViewTabapousiesdikDoc AS
SELECT Id, Epitheto,sum(adik) as dikaiologimenes FROM Tabapousiesdik
where dik=’Doc’ group by id,epitheto;
select * from ViewSumApousies
select * from ViewTabapousiesdik
select * from ViewTabapousiesdikKid
select * from ViewTabapousiesdikDoc