I don't undertand why I am having a problem with the following SELECT query.
It works fine in the database explorer but as soon as I try to run it in and
ADO Query component AND any of the fields in the joined tables are empty, I
get an error E_FAIL and an incomplete result set.  Any Ideas?  Thanks for
the help!

Ren Giesbrecht

Following is the SELECT statement:

SELECT Opportunity.Opp_Id, V_stSupportDate, V_stConsultant, V_stDuration,
V_stIncident, V_stResult, V_stReferredTo

FROM

(((((((Opportunity LEFT OUTER JOIN V_stSupportDate
  ON Opportunity.Opp_ID = V_stSupportDate.Opp_ID)

LEFT OUTER JOIN V_stConsultant
  ON Opportunity.Opp_Id = V_stConsultant.Opp_Id)

LEFT OUTER JOIN V_stDuration
  ON Opportunity.Opp_Id = V_stDuration.Opp_Id)

LEFT OUTER JOIN V_stIncident
  ON Opportunity.Opp_Id = V_stIncident.Opp_Id)

LEFT OUTER JOIN V_stResult
  ON Opportunity.Opp_Id = V_stResult.Opp_Id)

LEFT OUTER JOIN V_stBillable
  ON Opportunity.Opp_Id = V_stBillable)

LEFT OUTER JOIN V_stReferredTo
  ON Opportunity.Opp_Id = V_stReferredTo.Opp_Id)

WHERE Opportunity.Client_ID = '010126000023570513701C'