Community
Application Development and Automation 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: 
Read only

Data Extraction

Go to solution
Former Member

‎2008 Aug 07 5:16 PM

0 Likes
363

Hi,

I have a requirement. Based upon Vendor Number LFA1-LIFNR, I want to extract unique combination of 3 fields from 3 different tables. For example, LFT1-ZXXXX, LFT2-ZYYYY and LFT3-ZWWWW.

I am not suppose to extrct duplicate fields. For 1 vendor Number, the combination in the above sequence should be unique.

Is there anyway? Plz Help. Help will be surely rewarded.

Thanks

Creasy

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2008 Aug 07 5:31 PM

0 Likes
324

Hi,

Use DISTINCT keyword in your select query.

Regards,

Subramanian

2 REPLIES 2
Read only

Go to solution
Former Member

‎2008 Aug 07 5:23 PM

0 Likes
324

It would help if you would specify which tables and fields.

Rob

Read only

Go to solution
Former Member

‎2008 Aug 07 5:31 PM

0 Likes
325

Hi,

Use DISTINCT keyword in your select query.

Regards,

Subramanian