MySQL Forums
Forum List  »  Newbie

Re: JOIN Statment
Posted by: Peter Brawley
Date: December 03, 2012 05:54PM

You right clicked using what module of what software?

select 
username as 'UserName',             -- missing trailing comma
computer_id as 'ComputerID'         -- superfluous trailing comma
from jamfsoftware.users             -- lose quotes round db, table names
INNER JOIN jamfsoftware.usage_logs  -- ditto
  ON users.COL1=usage.COL2          -- missing ON clause, specify COL1, COL2

Suggestion: study the manual pages on JOIN, work through those examples.

Options: ReplyQuote


Subject
Written By
Posted
December 03, 2012 04:05PM
Re: JOIN Statment
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.