join query sytax

Complete full-featured tool for preview and download of SQL reports in your Joomla site.
Forum rules
This forum is not for any support questions/issues/features. Please use Support Center for such requests.
FDigital01
Posts: 2
Joined: April 20th, 2014, 9:02 pm
Name: Pamela

join query sytax

Post by FDigital01 » August 19th, 2014, 7: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

User avatar
Admin
Site Admin
Site Admin
Posts: 1576
Joined: October 21st, 2008, 5:39 pm
Name: Administrator
Browser: Chrome

Re: join query sytax

Post by Admin » August 20th, 2014, 12: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`;

FDigital01
Posts: 2
Joined: April 20th, 2014, 9:02 pm
Name: Pamela

Re: join query sytax

Post by FDigital01 » September 1st, 2014, 8:01 pm

that did not work either.

User avatar
Admin
Site Admin
Site Admin
Posts: 1576
Joined: October 21st, 2008, 5:39 pm
Name: Administrator
Browser: Chrome

Re: join query sytax

Post by Admin » September 2nd, 2014, 1:21 pm

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