topic Re: Data Extraction in Application Development and Automation Discussions

Data Extraction

Former Member — Thu, 07 Aug 2008 16:16:47 GMT

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

Re: Data Extraction

Former Member — Thu, 07 Aug 2008 16:23:11 GMT

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

Rob

Re: Data Extraction

Former Member — Thu, 07 Aug 2008 16:31:29 GMT

Hi,

Use DISTINCT keyword in your select query.

Regards,

Subramanian