>Not sure if it would make any difference, but I'd try moving the 2 iActiveFlag checks from the JOIN conditions to the WHERE clause.
>
>Regards,

He-he. As I said, I'm going in the circle. I moved them from where to join to test, if it makes a difference. It basically didn't and descreased the performance by few seconds (say, from 69 to 73).

I'm looking into projection right now, but doubt it will help. BTW, I removed part of the where and the peformance still decreases:

TEXT TO lcSQLStr NOSHOW TEXTMERGE PRETEXT 7
    SELECT Trans.cTrans_pk , ;
           IIF(not IsNull(Trans_Employees_Queues.cCommission_Owner_UsGrLink_fk), ;
               Trans_Employees_Queues.cCommission_Owner_Usgrlink_fk, ;
               Trans_Employees_Queues.cUsGrLink_fk) as cUsGrlink_pk, ;
           Trans.yCurrent_balance_amount as yBalance ;
    FROM TRANS ;
    INNER JOIN Trans_Employees_Queues ;
    ON Trans.cTrans_pk = Trans_employees_queues.cTrans_fk ;
    AND Trans_employees_queues.iActive_Flag = 1 ;
    INNER JOIN Employee_queue_schedules ;
    ON Trans_employees_queues.cTrans_employees_queues_pk = ;
     Employee_queue_schedules.cTrans_employees_queues_fk ;
    AND Employee_queue_schedules.iActive_Flag = 1 ; 
    WHERE <<m.lcFilter>>    
ENDTEXT