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

See Also