Query editor
with pricet as (select*from prices.latestwhere blockchain = 'hemi'unionselect*from prices.latestwhere contract_address = 0x7a56e1c57c7475ccf742a1832b028f0456652f97)selectdistinct t.contract_address,t.symbol,pricefrom tokens.erc20 tleft join pricet p on t.symbol = p.symbolwhere t.blockchain = 'bob'