views:

31

answers:

0

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')