Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to compare char in inner join.

Go to solution
Former Member

‎07-12-2010 10:52 AM

0 Kudos

Hi,

How to compare two field values of two different tables using inner join.

Two fields are char(10), But one value is = '44' , another field value = '044'

Please help me..

1 ACCEPTED SOLUTION

Go to solution
former_member182387
Active Participant

‎07-12-2010 11:17 AM

0 Kudos

Hi,

Better use FOR ALL ENTRIES..

First get the Table A details in to internal table, if th table contains '44', just add the 0 in front of the '44' using LOOP..ENDLOOP.

Then select the second table using FOR ALL ENTRIES...

Thanks and Regards,

Senthil Kumar Anantham.

1 REPLY 1

Go to solution
former_member182387
Active Participant

‎07-12-2010 11:17 AM

0 Kudos

Hi,

Better use FOR ALL ENTRIES..

First get the Table A details in to internal table, if th table contains '44', just add the 0 in front of the '44' using LOOP..ENDLOOP.

Then select the second table using FOR ALL ENTRIES...

Thanks and Regards,

Senthil Kumar Anantham.