I would like to do something like this
SELECT * FROM orders,subscriptions
WHERE orders.subscription_id = subscriptions.id
created created - INTERVAL subscriptions.term subscriptions.unit;
But I get ERROR 1064: You have an error in your SQL syntax near
'subscriptions.unit)'
---Original Message-
--From: Erik Osterman [mailto:[EMAIL PROTECTED]
--Sent: Wednesday, November 12, 2003 4:05 AM
--To: [EMAIL PROTECTED]
--Subject: A question on INTERVAL
--
--
--I would like to do something like this
--
--SELECT * FROM orders,subscriptions
-- WHERE