Denis,

As you have discovered, the SQL command must specify the relations you desire, as well as any filtering. Unless you are using an early version of FoxPro, you can use an INNER JOIN clause:

SELECT * FROM sp INTO TABLE (cMytemptab) ;
  INNER JOIN splink ON sp.spcode = splink.spcode ;
  WHERE &customwhere

Alternatively, you can put it all in the WHERE and FROM clauses, although the syntax above is more standard and more portable to other database systems. In this case, an INNER JOIN is implied:

SELECT sp.* FROM sp, splink INTO TABLE (cMytemptab) ;
  WHERE sp.spcode = splink.spcode ;
  AND &customwhere

>I am converting all my home-written queries into SQL. I am learning that I have to think differently! e.g. SQL does not respect normal filters. I also realise that my table relations are ignored in where clauses.
>
>1. The main table alias SP is related to a table with alias SPLINK on a
>field SPCODE.
>
>2. My where clause (&customwhere)is:
>sp.taxstat = 'ACC' and splink.habit = 'TR'
>
>3. My SQL select clause is:
>SELECT * FROM SP INTO TABLE (cMytemptab) WHERE &customwhere
>... does not work.
>
>Do I have to use a join statement?