Eko, you're not JOINing the two tables together - your database is
taking the time to produce a huge result set known as a cartesian
product, which is probably not what you want. You need to introduce an
additional WHERE clause specifying how the two tables should be JOINed, like
WHERE hiart0
I have a query statement like this
select hiart01a.cust, hiarf01.nama, hiarf01.al2, hiart01a.tgl, hiart01a.netto,
hiart01a.muka
from hiart01a, hiarf01
where hiart01a.tgl>=from_days(to_days(now()) - 180) and
hiart01a.tgl<=from_days(to_days(now()) - 30)
order by hiart01a.cust;
when I run
