Results 1 to 2 of 2

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
    No, that syntax is not correct for Microsoft SQL. The First() and Last() functions make me think the query is written for Jet, the database engine used by Microsoft Access (and other products).

    -PatP

Posting Permissions

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