Hi Rolf
Thanks for your response. I discovered the problem was with the semi colon after
price. Here is the query that I used...
SELECT * FROM kawarthas, Customer WHERE (DATE_SUB(CURRENT_TIMESTAMP, interval 36
HOUR)) < kawarthas.timestamp AND (kawarthas.agent1aid=Customer.MemberID) ORDER BY
price
Hi Ken,
Welcome to the list. You'll get great help here, best support I've ever
come across but you do need to do your own research first. Try reading the
relevant sections of the manual again but a little more thoroughly this
time.
To get you started, you're mixing C code with SQL code. You
