Results 1 to 2 of 2

Thread: Sql Error, Why?

  1. #1
    Join Date
    Oct 2003

    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 = j.a1, = j.a2;

    I have an error, the query is not actualizable.

    is this sql correct?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    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).


Posting Permissions

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