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?