General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only