必须用sql语句,如
Select * From {表A} Inner JOIN {表B} ON mid({表A}.第一列,3,3)= mid({表B}.第一列,3,3) where len({表A}.第一列) = 5
http://www.foxtable.com/webhelp/scr/0695.htm