Database

throw "a";

FieldsPtr ptrFields = NULL;
FieldPtr ptrField = NULL;

// assign the Fields that we have from the recordset
ptrFields = m_pRS->Fields;
int nCols = ptrFields->Count; 

FieldPtr ptrField = NULL;
_variant_t vCol((long)-1);
for (int i = 0; i < nCols; i++)
{
   vCol.lVal = i;
   HRESULT hr = ptrFields->get_Item(vCol, &ptrField);
   if(FAILED(hr))
      _com_issue_error(hr);
            
   // now check if the field exist
   if ((LPCSTR)ptrField->Name == "My Field")
   {
      // Do Something
   }
}

Select 
  Company.Name, Adress.Adress, email.email 
From 
  Company, Adress, email
where
  Company.ID = Address.id And
  Company.Id =* email.id

FROM 
         Company LEFT JOIN email ON 
         Company.ID = email.companyID

Select Company.*, email.email, phone.phone
FROM          
Company LEFT JOIN email ON          
Company.ID = email.companyID AND
Company LEFT JOIN phone ON
Company.ID = phone.companyID