Subject | Select with calculated field problem |
---|---|
Author | Рустам Муса-Ахунов |
Post date | 2017-11-28T14:33:30Z |
Try this:
select
A.CODSUB,
A.CODOB,
A.CODSBB,
A.CANT*B.CANT
from LSUBANS A
join X01 B on B.CODSBB = A.CODSUB
select
A.CODSUB,
A.CODOB,
A.CODSBB,
A.CANT*B.CANT
from LSUBANS A
join X01 B on B.CODSBB = A.CODSUB