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. answered 09 Sep '13, 09:15 JBSchueler 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
(09 Sep '13, 10:47)
mfkpie8
|
Some hints as to what does not work for you would be worthwhile - otherwise your suggestion seems "too inconvenient", methinks...
copy or input sql code too bad
Now I'd like to know whether the votes express the voters's opinion that
(1): I'll bet it's an OR here, not an XOR:)
My opinion, that markdown isn't acceptable and needs to improve, but tone of this suggestion is not appropriate.