November 30th, 2012, 07:11 AM
|
|
Registered User
|
|
Join Date: Nov 2012
Posts: 1
Time spent in forums: 25 m 9 sec
Reputation Power: 0
|
|
|
Inner join
Hi,
I'm hoping someone can help. I have two tables and i'm trying to extract data from both and combine into one, the problem is within phpmyadmin, I get this error
#1064 - 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 'ON 'users'.'job_id' = 'job_level'.'job_id' LIMIT 0, 30' at line 1
My query is as follows :
select users.id,users.first_name, users.last_name, users.reg_date from users INNER JOIN ON 'users'.'job_id' = 'job_level'.'job_id'
Could anyone tell me where I'm going wrong, I'd really appreciate it.
Regards,
Gary
Last edited by DJDOO : November 30th, 2012 at 07:24 AM.
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
