i want to print supplier code, supplier name,purchase order text(general terms and condition)

tccom020.suno,tccom020.nama,tdpur040.txt , tried to create sql query,the sql query is appearing multiple records. i want only 1 supplier code,name and text details of that supplier.
suno name txta
SUP.CD SUP.NAME TERMS CONDITION
AAAAAA ANANANANANANANAN DELIVERY PERIOD:15 DAYS
BBBBBBB BBBABABABABABABAB DELIVERY OERIOD 60 DAYS

please advice how to restrict multilple records and where to define the setup. if need to script please advice with sample script.

Thanks in advance

Select tdpur040.*, tccom020.suno, tccom020.nama
from tdpur040, tccom020
where tdpur040._index1 = {:someconditions}
and tccom020.suno = :tdpur040.suno
selectdo
endselect

Then you just print the fields you want.