I need help because I don't Know if I can open two recordset at the same time.
For example:

CRecordSetA RecordSetA(Database);
CRecordSetB RecordSetB(Database);

SelectA = "{CALL ProcedureA}"
SelectB = "{CALL ProcedureB}"

if (RecordSetA.Open(CRecordset::forwardOnly, SelectA, Recordset::readOnly)){
while (!RecordSetA.IsEOF()){
if (RecordSetB.Open(CRecordset::forwardOnly, SelectB, CRecordset::readOnly)) {
while (!RecordSetB.IsEOF()){
RecordSetB.MoveNext();
}
}
RecordSetB.Close();
RecordSetA.MoveNext();
}
}
RecordSetA.Close();


Can I make somthing like this?.
If I can, What must I put in the options to make this?
Thanks,
Reyes