Hello, have a tables related question 1

[ShyFox]

Hy, I'm new here so I salute you.
I would like to know how can I make a table from two tables.
They have three common fields: ID, Employes and Salary. How can I make another table with the same fields the only change is that this table is created every three months and the field Salary contains the sum of those three months. So if John has a 30 000 $ a month after three months he'll apppear in this table with 90 000$. The tables are not related and I can change them only for the moment when I extract the data. So I can't make a tag or use them in exclusive mode.

 

[baltman]

I think this would do what you want...

select distict ID, Employes , sum(Salary) as salary ;
group by 1 into table Quarterly

 

[furmious]

Wouldn't it be a bit more like this?

sele f.id,f.employes,sum(s.salary);
from firsttblname as f,secondtblname as s;
group by s.id;
into dbf quarterly

 

[ShyFox]

furmious (TechnicalUser)
Thank you !!!!
Thank you all!
Regards.