MySQL Forums :: Newbie :: JOIN Statment
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?
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?
| 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.
© 2013, Oracle Corporation and/or its affiliates