# Influxdb error querying multiple measurement

**URL:** <https://community.influxdata.com/t/influxdb-error-querying-multiple-measurement/25345>\
**Category:** InfluxDB 2\
**Created:** [June 8, 2022, 4:08pm UTC](https://community.influxdata.com/t/influxdb-error-querying-multiple-measurement/25345 "2022-06-08T16:08:19Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![mofolu](https://avatars.discourse-cdn.com/v4/letter/m/b3f665/32.png) [@mofolu](https://community.influxdata.com/u/mofolu)\
**Post date:** [June 8, 2022, 4:08pm UTC](https://community.influxdata.com/t/influxdb-error-querying-multiple-measurement/25345/1 "2022-06-08T16:08:19Z")

</div>

I am trying to query multiple measurement in same query in influxdb. The result returned usually come from just one table, when I run the queries individually I get result when I run all, I get result for just one measurement eg.  
Q1= from (bucket:“example)  
|\> range(start:30d)  
|\> filter(fn: (r) =\> r[“tag”] == “blah”)  
|\> filter(fn: (r) =\> r[”\_measurement"] == “ghgh” )  
|\> filter(fn: (r) =\> r["\_field"] == “gggg” )  
|\> aggregateWindow(every: 1s, fn: first, createEmpty: true)  
|\> fill(usePrevious: true)  
|\> yield(“first\_table”)

Q2= from (bucket:“example)  
|\> range(start:30d)  
|\> filter(fn: (r) =\> r[“tag”] == “blah”)  
|\> filter(fn: (r) =\> r[”\_measurement"] == “hjjjj” )  
|\> filter(fn: (r) =\> r["\_field"] == “ffff” )  
|\> aggregateWindow(every: 1s, fn: first, createEmpty: true)  
|\> fill(usePrevious: true)  
|\> yield(“second\_table”)

Q3= from (bucket:“example)  
|\> range(start:30d)  
|\> filter(fn: (r) =\> r[“tag”] == “blah”)  
|\> filter(fn: (r) =\> r[”\_measurement"] == “yyyy” )  
|\> filter(fn: (r) =\> r["\_field"] == “fdfdfd” )  
|\> aggregateWindow(every: 1s, fn: first, createEmpty: true)  
|\> fill(usePrevious: true)  
|\> yield(“third\_table”)

running this type of query returns just one of the query, however running them separately yields result for the three queries, join doesnot work either

---

<div class="post-metadata">

**Author:** ![Jay\_Clifford](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/jay_clifford/32/8287_2.png) [@Jay\_Clifford](https://community.influxdata.com/u/Jay_Clifford)\
**Post date:** [June 9, 2022, 2:15pm UTC](https://community.influxdata.com/t/influxdb-error-querying-multiple-measurement/25345/2 "2022-06-09T14:15:50Z")

</div>

Hi @mofolu,  
For performance reasons always start with your measurement. Other than that your query is fine. What UI component are you using to visualise the table?

---

<div class="post-metadata">

**Author:** ![mofolu](https://avatars.discourse-cdn.com/v4/letter/m/b3f665/32.png) [@mofolu](https://community.influxdata.com/u/mofolu)\
**Post date:** [June 9, 2022, 2:29pm UTC](https://community.influxdata.com/t/influxdb-error-querying-multiple-measurement/25345/3 "2022-06-09T14:29:39Z")

</div>

I switched to using tags first cause I read it was faster performance wise, thanks for the update. I am using influxdb UI

---

<div class="post-metadata">

**Author:** ![Jay\_Clifford](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/jay_clifford/32/8287_2.png) [@Jay\_Clifford](https://community.influxdata.com/u/Jay_Clifford)\
**Post date:** [June 10, 2022, 8:55am UTC](https://community.influxdata.com/t/influxdb-error-querying-multiple-measurement/25345/4 "2022-06-10T08:55:38Z")

</div>

Hi @mofolu,  
What UI visualisation type are you using though? (table, graph, etc.). Also what version of InfluxDB are you using? 🙂

---

<div class="post-metadata">

**Author:** ![mofolu](https://avatars.discourse-cdn.com/v4/letter/m/b3f665/32.png) [@mofolu](https://community.influxdata.com/u/mofolu)\
**Post date:** [June 10, 2022, 3:28pm UTC](https://community.influxdata.com/t/influxdb-error-querying-multiple-measurement/25345/5 "2022-06-10T15:28:54Z")

</div>

I am using a table.  
Influxdb 2.0.9

---

<div class="post-metadata">

**Author:** ![Jay\_Clifford](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/jay_clifford/32/8287_2.png) [@Jay\_Clifford](https://community.influxdata.com/u/Jay_Clifford)\
**Post date:** [June 14, 2022, 7:48am UTC](https://community.influxdata.com/t/influxdb-error-querying-multiple-measurement/25345/6 "2022-06-14T07:48:58Z")

</div>

@mofolu  
could you upgrade to 2.2 and check the raw table view instead. We can then see if this is just a bug with 2.0.9’s table UI.