Hi,
I have attached the API XML.
I have looked at autoquery and it does the job for some of my questions, however I have not been able to find info on specifying table joins from the URL.
So I have used plain SQL.
SELECT
main.LastSavedDateTime,
main.InventoryID,
main.PartNo,
main.Description,
main.Status,
main.DefaultPrice,
main.RRPPrice,
main.Aux2,
main.BackOrderable,
price.InventoryID,
price.Price1,
price.Price2,
price.Price3,
price.Price4,
price.Price5
FROM IN_Main main
LEFT JOIN
IN_SellingPrices price
ON
price.InventoryID=main.InventoryID
ORDER BY main.InventoryID
OFFSET @StartPosition
ROWS FETCH NEXT @NumberRows
ROWS ONLY;
The problem is, it only returns the table fields from the IN_Main table, not from the IN_SellingPrices table. I need all of the fields requested in the SQL.
How can I get these fields returned as well?
Cheers