|
On this page you can modify SQL query that PHPRunner has built for
you automatically. In most cases you can proceed with default SQL query.
There are three modes:
- Query Designer
- SQL tab where you can edit SQL query manually.
- Result tab where you can see result of edited query.
Select ID,
OrderDate,
CustomerID
from OrderHeader
 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 functionality.
Also you can enter number of records to appear on each list page.
If you'd like to specify default sorting order on the list page
(ascending or descending) you can do so by using the ORDER BY on the
list page option.Select necessary fields, move them to the right
window using arrow buttons and choose sorting order by clicking on
the ASC cell (ascending sorting is the default setting).
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
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
|
