join query sytax
Forum rules
This forum is not for any support questions/issues/features. Please use Support Center for such requests.
This forum is not for any support questions/issues/features. Please use Support Center for such requests.
-
- Posts: 2
- Joined: April 20th, 2014, 9:02 pm
- Name: Pamela
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? 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
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
-
- Site Admin
- Posts: 1010
- Joined: October 21st, 2008, 5:39 pm
- Name: Administrator
- Browser: Chrome
Re: join query sytax
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`;
-
- Posts: 2
- Joined: April 20th, 2014, 9:02 pm
- Name: Pamela
Re: join query sytax
that did not work either.
-
- Site Admin
- Posts: 1010
- Joined: October 21st, 2008, 5:39 pm
- Name: Administrator
- Browser: Chrome
Re: join query sytax
Please contact Support Center and inform Joomla super user login details:
https://alterbrains.zendesk.com/login
https://alterbrains.zendesk.com/login