Joining two Measurements Shows No Results

Fluxlang
1

Hi I am trying to query fields from two different measurements and join them. Whey I query the fields independently I am able to see the data but when I join them I get no results. I followed the template on the InfluxDB site but not getting any results. I am using InfluxDB 1.8 with flux enabled. Here is the query that I issued but getting no results. Am I doing something wrong here?

table1 = from(bucket: "test_db/autogen")
  |> range(start: 2020-10-21T06:30:00Z, stop: 2020-10-21T15:00:00Z)
  |> filter(fn: (r) => r._measurement == "measurementb_a")
  |> filter(fn: (r) => r["_field"] == "field_abc")
  
table2 = from(bucket: "test_db/autogen")
  |> range(start: dashboardTime)
  |> filter(fn: (r) => r._measurement == "measurement_a")
  |> filter(fn: (r) => r["_field"] == "field_xyz")
  
join(tables: {key1: table1, key2: table2}, on: ["_time", "_field", "host"])

Thanks for the help in advance

2

This was an error on my part. I mixed the time ranges with a start stop range and dashboardTime. Updating to start stop time range fixed my issue.