Problems with SQL stmt in Hyperscript

Hi all, I am using this SQL statement in Hyperscript: select milestone_cat, initiative_id, vsmapjct.projid, vsmapjct.majrelid, sum(plan_st_fin_diff), sum(act_st_fin_diff) , qtr, yr from vsmapjct, vsmaipxr where vsmapjct.projid = vsmaipxr.projid and vsmapjct.majrelid = vsmaipxr.majrelid group by initiative_id, vsmapjct.projid, vsmapjct.majrelid, milestone_cat,qtr, yr order by initiative_id , vsmapjct.projid, vsmapjct.majrelid, milestone_cat, qtr, yr; The number of records retrieved from the database (using DATALINK) is 15, which is incorrect. The number of records retrieved from the database directly using native isql is 40 which is correct. I check the number of rows from the database by setting num_rows = DB:DBGetVal() right after the DB:DBSEND and DB:DBEXEC() commands. Help, this was suppose to be cut into production last Friday. I can fax the entire script (6 pages) to whomever if it's needed. Thanks a bunch Felicia Hemingway (908) 699-8182 feliciah@base.bellcore.com BELLCORE