JOIN
In ARDI SQL queries, the JOIN select property doesn't join queries - it instead joins ASSETS via their relationships.
It takes the form of 'JOIN <relationship> ON <down>'. So for example, the below query…
SELECT 'Speed' FROM 'Machine' JOIN 'Location' ON 'down'
…will select the speed from every asset inside-and-including the asset called 'Machine'.
Examples
SELECT 'Current' FROM 'Power Meter PM4-26' JOIN 'AC Power' ON 'down'
Gets the amount of current being consumed on every power meter down-stream from power meter PM4-26