Error in Query - need help

From: MD (banglait_at_yahoo.com)
Date: 03/15/04

  • Next message: Vishal Parkar: "Re: Error in Query - need help" 
    Date: Mon, 15 Mar 2004 13:59:28 -0800

    I get the following strange error when executing the query
    below. Can anyone help me find the error ? thanks in
    advance.

    Server: Msg 207, Level 16, State 3, Line 1
    Invalid column name 'A'.
    ----------------------------------------

    Query:

    SELECT A1.EecSupervisorID, A1.EecEmplStatus,
    CC.EecEmpNo, '1' AS Approver INTO EmpLoad.dbo.Tbl_Approver
    FROM
    (frdhrdb1.ultipro_lti.dbo.EmpComp as A1
     INNER JOIN frdhrdb1.ultipro_lti.dbo.EmpPers as BB
    ON A1.EecSupervisorID = BB.EepEEID)
     LEFT JOIN frdhrdb1.ultipro_lti.dbo.EmpComp AS CC ON
    BB.EepEEID = CC.EecEEID
    GROUP BY A1.EecSupervisorID, A1.EecEmplStatus, CC.EecEmpNo
    HAVING (((A1.EecEmplStatus)="A"));

  • Next message: Vishal Parkar: "Re: Error in Query - need help"

    Relevant Pages

    • Syntax of like statement using a variable
      ... when I try all different types of syntax it either gives ... me invalid column name on the mystr variable or returns 0 ... When I do this in access and paste to a query it ... SFORDFIL_SQL.ord_no = SFDTLFIL_SQL.ord_no) INNER JOIN ...
      (microsoft.public.access.modulesdaovba)
    • Re: correlated subquery in the crosstab
      ... FROM (tblStudent INNER JOIN (tblClass INNER JOIN ... values from the outer query and I have made an alias for it. ... I have students, courses, exam groups containing exams of courses, ... that the crosstab query in access has much more capablities than ...
      (microsoft.public.access.queries)
    • Re: correlated subquery in the crosstab
      ... I solved my problem using stored queries to act as subqueries. ... FROM (tblStudent INNER JOIN (tblClass INNER JOIN ... values from the outer query and I have made an alias for it. ... that the crosstab query in access has much more capablities than ...
      (microsoft.public.access.queries)
    • Re: correlated subquery in the crosstab
      ... The first query ... TRANSFORM FirstAS FirstOfscore ... FROM tblStudent INNER JOIN (((tblEduYear INNER JOIN tblExamGrp ON ... that the crosstab query in access has much more capablities than ...
      (microsoft.public.access.queries)
    • Re: Return just the first record that fits the parameter
      ... Be warned that coordinate subqueries are slow since they run the query one time for each record in the main query. ... FROM tblProcess INNER JOIN ... This is the only record for Plan 06-22. ... It would be convenient to be able to use "ABC 10" as the criteria for ProcName, and return all Plans that include that Process. ...
      (microsoft.public.access.queries)