Re: JOIN Statment
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.
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.