Splunk DB Connect: How to edit my dbxquery to use a field value from one SELECT query in another SELECT query?

[sharmasplunk]

| 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?

[plynch52]

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