====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...

<code>
SELECT 'Speed' FROM 'Machine' JOIN 'Location' ON 'down'
</code>

...will select the speed from //every asset inside-and-including the asset called 'Machine'//.

===Examples===

<code>
SELECT 'Current' FROM 'Power Meter PM4-26' JOIN 'AC Power' ON 'down'
</code>

//Gets the amount of current being consumed on every power meter down-stream from power meter PM4-26//

===See Also===

[[SELECT]]