|
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. This is required to provide edit/delete functionality.
To switch between tables use Tables list
panel on the left.
What
is supported
Select ID,
OrderDate,
CustomerID,
OrderDetail.ID as DetailID,
OrderDetail.Quantity as ProductQuantity
from Orders
inner join OrderDetail on
Orders.ID = OrderDetail.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,
UnitPrice,
UnitPricePrice*0.05 as Tax
from Products
select * from customers where country='UK'
For more complicated queries wrap condition by brackets:
select * from customers where (country='UK' or country='USA')
SQL query:
Select ProductName,
CategoryID,
SUM(UnitPrice)
from Products
GROUP BY ProductID, ProductName, CategoryID, UnitPrice
ORDER BY ProductName
What is not supported
|
