How to correlate index with dbxquery with condition or interation?

[LearningGuy]

How to correlate index with dbxquery with condition or interation?

See the sample below.   Thank you for your help.
index=company

CompanyID	CompanyName	Revenue
A	CompanyA	3,000,000
B	CompanyB	2,000,000
C	CompanyC	1,000,000

|  dbxquery query="select * from employee where companyID in (A,B,C)"
OR 
Iteration:
|  dbxquery query="select * from employee where companyID ='A'
|  dbxquery query="select * from employee where companyID ='B'
|  dbxquery query="select * from employee where companyID ='B'

CompanyID	EmployeeName	EmployeeEmail
A	EmployeeA1	empA1@email.com
A	EmployeeA2	empA2@email.com
A	EmployeeA3	empA2@email.com
B	EmployeeB1	empB1@email.com
B	EmployeeB2	empB2@email.com
B	EmployeeB3	empB3@email.com
C	EmployeeC1	empC1@email.com
C	EmployeeC2	empC2@email.com
C	EmployeeC3	empC3@email.com

Expected result:

CompanyID	CompanyName	Revenue	EmployeeName	EmployeeEmail
A	CompanyA	3,000,000	EmployeeA1	empA1@email.com
A	CompanyA	3,000,000	EmployeeA2	empA2@email.com
A	CompanyA	3,000,000	EmployeeA3	empA2@email.com
B	CompanyB	2,000,000	EmployeeB1	empB1@email.com
B	CompanyB	2,000,000	EmployeeB2	empB2@email.com
B	CompanyB	2,000,000	EmployeeB3	empB3@email.com
C	CompanyC	1,000,000	EmployeeC1	empC1@email.com
C	CompanyC	1,000,000	EmployeeC2	empC2@email.com
C	CompanyC	1,000,000	EmployeeC3	empC3@email.com

OR 

CompanyID	CompanyName	Revenue	EmployeeName	EmployeeEmail
A	CompanyA	3,000,000	EmployeeA1, EmployeeA2, EmployeeA3	empA1@email.com, empA2@email.com, empA2@email.com
B	CompanyB	2,000,000	EmployeeB1, EmployeeB2, EmployeeB3	empB1@email.com, empB2@email.com, empB3@email.com
C	CompanyC	1,000,000	EmployeeC1, EmployeeC2, EmployeeC3	empC1@email.com, empC2@email.com, empC3@email.com

[LearningGuy]

Hello @richgalloway ,
Thanks for your help.   It's odd that I didn't receive notification when you responded.
1) It looks like it also works if I do the index first, then DBX query. 
2) How do I put company ID in the brackets on DBX query dynamically?
    eval variable = .....   A, B, C, ...   Z  (Company ID) 
    where companyID in $variable$

index=company
| append
[ | dbxquery query="select * from employee where companyID in (A,B,C)"
| stats values(*) as * by CompanyID

[richgalloway]

Run both queries then combine the results using stats.

| dbxquery query="select * from employee where companyID in (A,B,C)"
| append [search index=company]
| stats values(*) as * by Company ID