What is here distinct(a.title) for? Do you have any custom procedure with the name "distinct"?



>I am using the following query using distinct and like both, Can you please tell me am i doing something wrong, it is not getting the records.
>But there are records which match the criteria:
>
>###################################################################
>Select distinct(a.title),b.docindex_i from ocrdata a,docudeck b ;
>where a.tiffile = b.file_name ;
>and a.ocdata like "%schedule%" ;
>order by a.id into cursor lcsource
>###################################################################
>
>Thank you very much.