AlterBrains

Posted: **August 19th, 2014, 8:53 pm**

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? can anyone help?

Error in query!
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.1 JOIN '#__osmembership_plans' as table.2 ON table.1`plan_id`=table.2`id`; WHER' at line 1 SQL=SELECT * FROM `nsqt_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`;

Error in query!
SQL error: 1064

thankyou

Posted: **August 20th, 2014, 1:39 pm**

Don't use dots in table aliases:

Code: Select all

SELECT * FROM `#__osmembership_subscribers` AS table1
JOIN '#__osmembership_plans' AS table2
ON table1.`plan_id` = table2.`id`;
WHERE DATE_SUB(CURDATE(),INTERVAL 90 DAY) <= `from_date`;

Posted: **September 1st, 2014, 9:01 pm**

that did not work either.

Posted: **September 2nd, 2014, 2:21 pm**

Please contact Support Center and inform Joomla super user login details:
https://alterbrains.zendesk.com/login

AlterBrains

join query sytax

join query sytax

Re: join query sytax

Re: join query sytax

Re: join query sytax