>hello everybody,
>
>I have syntax error in the following SQL statement, how should I fix it?
>
>(select distinct cust_code from depositer);
>intersect;
>(select distinct cust_code from borrower)
>
>I just copied the statement from my reference book, does VFP have different syntax when process SQL statement?

VFP does not support the full ANSI SQL syntax, it does not support INTERSECT. You could use a subquery, something like

SELECT DISTINCT cust_code FROM depositer ;
  WHERE depositer.cust_code IN (SELECT DISTINCT cust_code FROM borrower) ;
  ...