MySQL Forums
Forum List  »  Newbie

JOIN Statment
Posted by: matt ha
Date: December 03, 2012 04:05PM

I am new to MySQL and I am having issues getting a simple SQL statement to work

username as 'UserName'
computer_id as 'ComputerID',
from 'jamfsoftware'.'users' INNER JOIN 'jamfsoftware'.'usage_logs'

This only gives me errors. I right clicked on my Table/Column and picked SELECT ROWS - LIMIT 1000 and that is how I got the exact DB and TABLE name.

But as I said I can't run this since it gives errors. What did I do wrong?

Options: ReplyQuote

Written By
JOIN Statment
December 03, 2012 04:05PM
December 03, 2012 05:54PM
December 03, 2012 06:02PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.