>>Here is my code:
>>select tabletest1.order_date,;
>>tabletest2.custno,;
>>tabletest2.amount;
>>from tabletest1;
>>left join tabletest2 on tabletest1.custno = tabletest2.custno;
>>where substr(dtoc(tabletest1.order_date),7,2) = '99'
>>
>>I am picking up all the records in tabletest1 instead of just the
>>matches found with tabletest1.custno = tabletest2.custno? any ideas?
>
>Take out the LEFT JOIN - just make it a JOIN.
----
yea, that works..thanks..:)