When executing the query below using AT instead of "T" as a join alias, the following error is returned: "IErrorInfo.GetDescription failed with E_FAIL (0x80004005). "
OleDbDataAdapter da = new OleDbDataAdapter("SELECT A.*, " +
" T.alcadaTipo as alcadaTipoDescricao " +
" FROM tblAlcada A " +
" INNER JOIN tblAlcadaTipo T " +
" ON T.alcadaTipoId = A.alcadaTipo", conn);
Would anyone please explain why?