Skip to Content
0
Jul 21, 2016 at 07:31 AM

BP master query repeated lines problem

34 Views

Hi Experts,

while linking OCRD table and OCPR table am getting repeated lines in my query. i.e In my Bp master 5 different contact persons names but i have set one contact person name as default. At the time of executing query with OCRD and OCPR table all BP name repeated 5 times How to solve this issue.

Please find the attachment for reference

select t0.cardcode,t0.cardname,t1.name,t1.E_mail,t1.tel1 from ocrd t0 inner join ocpr t1 on t0.cardcode=t1.cardcode

Thanks & Regards

vinoth

Attachments

Capture.JPG (56.2 kB)