Skip navigation links

MySQL Forums :: Newbie :: JOIN Statment


Advanced Search

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 matt ha 12/03/2012 04:05PM
Re: JOIN Statment Peter Brawley 12/03/2012 05:54PM
Re: JOIN Statment Barry Galbraith 12/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.