You need to join unic field from both table so after joining unic field what you want to be displayed that you need to give in out put format. Suppost in SQVI you are joining table you need to select join tabble then take required table, join these table with unic table & then finally give report Hope will help you. Trupti
| | | ---------------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 _.____.__ |