Query only selecting last item of results

Hello

I'm building the index of my search engine. I select a few columns from two tables and join on a ID

select DISTINCT a.tclm, a.tableid, a.tid, b.oid,  b.tid, b.subcname, b.pro4, b.subcid
from tblinfo a,  subc b
where a.tid = b.tid

after I dump the results it looks ok... but when I search for a part number from a group of the same ID number, it only returns the last part of the list... the search doesnt see all the parts.

any help would be appreciated

Thanks!