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