on 2013 Sep 08 2:21 PM
I hope I understand what you are having trouble with.
For inputting SQL code, just copy / paste and then apply the little icon with the 101/010 on it to the code. And then you get something like this...
CREATE VIEW GROUPO.ViewSalesOrders (ID,LineID,ProductID,Quantity,OrderDate,ShipDate,Region,SalesRepresentativeName) AS SELECT i.ID,i.LineID,i.ProductID,i.Quantity, s.OrderDate,i.ShipDate, s.Region,e.GivenName||' '||e.Surname FROM GROUPO.SalesOrderItems AS i JOIN GROUPO.SalesOrders AS s JOIN GROUPO.Employees AS e WHERE s.ID=i.ID AND s.SalesRepresentative=e.EmployeeID;
That's all there is to it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks ! I think I will can you help me this question the web site was :http://sqlanywhere-forum.sap.com/questions/18168/how-i-can-use-of-recursive-query-results-help-thanks
User | Count |
---|---|
69 | |
8 | |
8 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.