I execute a sql query in the database and the code was like,

Select a.comcod, a.actcode, b.actdesc, a.rescode, c.resdesc, a.trnam, a.refnum, a.vounum

from actrna as a

inner join acinf as b on a.comcod=b.comcod and a.actcode=b.actcode

inner join sirinf as c on a.comcod=c.comcod and a.rescode =c.sircode

where a.comcod=3305 and a.tranam> 1000000.000000

Note: datatypes as defined earlier. I like to mention specially that vounum is the primary key of the table actrna as a and datatype is nchar(14)