|
|
On the SQL tab you can
modify SQL query manually. All changes on this tab automatically
transfer to the Query Designer.
 Note: if you
modify default SQL query, make sure that key column(s) are included
into fields list. This is required to provide edit/delete/view
functionality.
To switch between tables use
Tables
list panel on the
left.
What is
supported
SQL query:
SELECT
carsmodels.id,
carsmodels.model,
carsmodels.make
FROM carsmodels
INNER JOIN carsmake ON carsmodels.make = carsmake.make
|
More info
on using JOIN SQL
queries.
Note: It's
recommended to use aliases for fields from joined tables to avoid
confusion when two from different tables have the same name.
SQL query:
SELECT
id,
Make,
Model,
YearOfMake,
Picture,
Horsepower,
EPACity,
Price,
color,
features,
price*0.1 AS discount
FROM carscars
|
SQL query:
SELECT *
FROM carscars
WHERE YearOfMake =2004
|
For
more complicated queries wrap
condition by brackets:
SELECT *
FROM carscars
WHERE ( YearOfMake =2004 OR YearOfMake =2005 )
|
What is
not supported
Note:
If your
query for some reason doesn't work create view/query in your
database and use this query as a datasource in
ASPRunnerPro.
-
Run MS Access and create new query. Switch to SQL view.
-
Type your SQL query
there.
-
Save this query as
qryNewQuery.
-
Run ASPRunnerPro and
use qryNewQuery as datasource
table.
|
