:-( Nope - still gives the same error.

>Maybe because you mix SQL-89 and SQL-92? Change to
>
> FROM
> log L JOIN client C
> ON
> C.code = L.acc_Num
> JOIN clnt_sub S
> ON
> S.code = L.acc_num
> AND S.sub_code = L.sub_code
> WHERE
> L.POS_ID = :POSID
> AND L.SHIFTNUM = :SHIFTNUM

[Non-text portions of this message have been removed]