hey everybody, i am trying to display the result for following query in an html file which i want to call from custom pos button. can anybody help me with that. any guidence or any idea wold be much appreciated. the query is as follows+
SELECT [Transaction].Time, [Transaction].TransactionNumber, TransactionEntry.Price, TransactionEntry.Quantity,Item.Description FROM TransactionEntry INNER JOIN [Transaction] ON TransactionEntry.TransactionNumber [Transaction].TransactionNumber AND TransactionEntry.StoreID = [Transaction].StoreID INNER JOIN Customer ON [Transaction].CustomerID=Customer.ID LEFT JOIN Item ON TransactionEntry.ItemID = Item.ID LEFT JOIN Store ON TransactionEntry.StoreID = Store.ID WHERE Item.ItemLookUpCode='0000001'AND Customer.AccountNumber='0000001'