CODEWITHSUNDEEP
sqlinfluxdbinfluxql
Sai Sushanth
Sai Sushanth

Reputation: 69

How to achieve the following sql query in influx?

Given a SQL query below with an IN clause, is there a way in influx to achieve the same output produced by this?

SELECT * FROM Suppliers
WHERE Country IN (SELECT Country FROM Customers)

Upvotes: 1

Views: 235

Answers (1)

darkDragon
darkDragon

Reputation: 465

Influxql does not support IN clause with SELECT statement. Refer here:

One option for you is to demoralize your measurement by flagging(adding additional column) the point in measurement-suppliers which has corresponding matching point within measurement-customers.

Upvotes: 2

Related Questions