Can someone help me translate this query into a dBase equivalent expression?
select top 300 *
from CONTACT1 c1
left join CONTACT2 c2 ON c1.ACCOUNTNO=c2.ACCOUNTNO
where KEY1='10INQA'
and KEY2='2011 Fall'
and c1.ACCOUNTNO NOT IN (select accountno from CONTSUPP where RECTYPE='E')