Inner join

Hi,

While using inner join can we compare 2 feilds with diiferent lengths.

We have used following coding but it is giving error. Plz help me to solve it & get reward.

SELECT P_{AGR_NAME P}LANGU P_{PROFILE P}PTEXT

INTO TABLE T_AGR_PROF

FROM AGR_PROF AS P

INNER JOIN

UST12 AS U

ON <b>U_{auth(10) = P}PROFILE</b>

WHERE U_{OBJCT in S_OBJCT AND U}FIELD in S_FIELD AND U~VON in S_VON.

Thanks in advance.