|
On this page 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
Select ID,
OrderDate,
CustomerID,
b.ID as DetailID,
b.Quantity as ProductQuantity
from OrderHeader a
inner join OrderDetail b on
a.ID = b.OrderID
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.
Select ProductName,
Quantity,
Price,
Price*0.05 as Tax
from OrderDetails
select *
from customers where customertype='A'
For more complicated
queries wrap condition by brackets:
select *
from customers where (customertype='A'
or customertype='B')
What
is not supported
If your query
for some reason doesn't work create view/query in your database and
use this query as a datasource in ASPRunner.
1. Run MS
Access and create new query. Switch to SQL view.
2. Type your
SQL query there.
3. Save this
query as qryNewQuery.
4. Run ASPRunner
and use qryNewQuery
as datasource table.
|
