Results 1 to 3 of 3

Thread: Sql Error, Why?

  1. #1
    Join Date
    Oct 2003
    Posts
    6

    Unanswered: Sql Error, Why?

    UPDATE jose INNER JOIN (SELECT First(jose.a) AS a1, Last(jose.a) AS a2, jose.valor, Count(jose.valor) AS CuentaDevalor FROM jose GROUP BY jose.valor HAVING (((Count(jose.valor))>1))) AS j ON jose.valor = j.valor SET jose.ai = j.a1, jose.af = j.a2;

    I have an error, the query is not actualizable.

    is this sql correct?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    That depends. Not for Microsoft SQL Server, but it looks ok at first blush for Jet, the database engine used by Microsoft Access.

    Please don't cross post, or at least be up-front about cross-posting if you aren't sure where to post the question.

    -PatP

  3. #3
    Join Date
    Jan 2005
    Posts
    31
    See the Access forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •