As I said, if Rajiv knows the values of all the additional fields in the key of each table, it would be possible to get one value out of those subsequent tables. Otherwise, joining to a non-key field and having it be unique might work today, but would be subject to change at any time, causing the query to give erroneous results. - Lou
| | | ---------------Original Message---------------
From: rajivvarma
Sent: Tuesday, May 24, 2011 6:03 AM
Subject: How to join tables VBAK,VBAP,VBREVE,VBREVK,VEDA
Hi Experts,
I have requirement to use VBAK,VBAP,VBREVE,VBREVK,VEDA.Could you please tell me how to join these tables in right manner to avoid duplicates.
I have tried linking all the tables to VBAK but it is creating duplicates so please guide me right join condition to use these tables.
Thanks & Regards,
Rajiv. |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Popular White Papers
In the Spotlight Visit IBM's Leveraging IT Services Briefing Center. Register now and learn how to deliver smarter security & resiliency.  _.____.__ |
