Search found 2 matches

by FDigital01
September 1st, 2014, 9:01 pm
Forum: Alter Reports
Topic: join query sytax
Replies: 3
Views: 10752

Re: join query sytax

that did not work either.
by FDigital01
August 19th, 2014, 8:53 pm
Forum: Alter Reports
Topic: join query sytax
Replies: 3
Views: 10752

join query sytax

I am having trouble with the syntax to join 2 tables.

SELECT * FROM `#__osmembership_subscribers` as table.1
JOIN '#__osmembership_plans' as table.2
ON table.1`plan_id`=table.2`id`;
WHERE DATE_SUB(CURDATE(),INTERVAL 90 DAY) <= `from_date`;

this is the error message, but i am not sure what it means ...