Skip to Content
0
Former Member
Sep 20, 2007 at 07:02 AM

Inner join

21 Views

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 PAGR_NAME PLANGU PPROFILE PPTEXT

INTO TABLE T_AGR_PROF

FROM AGR_PROF AS P

INNER JOIN

UST12 AS U

ON <b>Uauth(10) = PPROFILE</b>

WHERE UOBJCT in S_OBJCT AND UFIELD in S_FIELD AND U~VON in S_VON.

Thanks in advance.