Subquery in WHERE statement

GoWebProd December 30, 2017, 12:22am 1

Hello, how I can make request like this:

SELECT * FROM disk WHERE host = (SELECT “host” FROM docker_container_cpu WHERE “engine_host” =~ /^$host$/)

Topic		Replies	Views
Using a subquery to do a count limited by a where clause influxql	2	2532	May 5, 2017
How to perform ASC and DESC in subqueries	2	815	July 25, 2019
Where clause not working as expected Fluxlang	2	464	July 6, 2020
SELECT from a SELECT? Or? Dashboards	3	980	April 25, 2017
Use Limit operator with Group BY clause and where clause	0	477	March 31, 2017