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

select
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


Subject
Written By
Posted
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.