| dbxquery connection=DB1
query="SELECT field1 FROM table1 where field2=11193193"
shortnames=1|RENAME field1 as field2| FIELDS SR_BUG_ID |appendcols [dbxquery connection="DB2" query="SELECT
field3 FROM table2 where field1 =field2" shortnames=1]|table *
when i am running this query, field2 is coming as unknown. Could you please tell me how i can use field1 value coming in first SELECT query in second SELECT query?
The sub query gets run before the rest of the query, so field2 has not been populated yet.
Dry making the first part the sub query