td-engine - 填TDengine数据库不能用join？

Question

taos> select avg(t0.c1) from t0, t1 where t0.ts = t1.ts and t0.ts > "2021-10-01 00:00:00.000" and t0.ts < "2021-10-01 00:00:54.000" interval(10s)
fill(prev);
ts | avg(t0.c1) |
======================================================
2021-10-01 00:00:00.000 | 467216751.000000000 |
2021-10-01 00:00:10.000 | 319952252.000000000 |
2021-10-01 00:00:20.000 | -755506094.000000000 |
2021-10-01 00:00:30.000 | 146424012.000000000 |
2021-10-01 00:00:40.000 | -417885709.500000000 |
Query OK, 5 row(s) in set (0.015457s)

从上面的sql命令可以看出join可以和fill一起使用。但是从TDengine官方文档来看，join查询不能和fill一起使用。那么我应该如何使用这个查询呢？

标签： td-engine