-->-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 orde
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)
