Re: [sqlite] Sub-Select

[Michael Knigge]

Hi,
sorry... I forgot.... I get the error "no such column: Sub.Sendung".... 
So I guess/hope it's only a "syntax error" with my SQL - my SQL-Skills 
are rather bad ;-(

Thanks,
  Michael

All,
could someone please tell me why this query doesn't work with 3.1.3 
(with 3.0.8 it works):

SELECT   max(Sub.Sendung)
FROM
(SELECT  S.Sendung
 FROM     Auftrag AS A,
          Sendung AS S
 WHERE    (A.PosyDat = 1 AND A.PosyDat = S.PosyDat) AND
          (A.PosyNId = 6 AND A.PosyNId = S.PosyNId) AND
          (A.DateiNum = 1 AND A.DateiNum = S.DateiNum) AND
          (A.ReprintNum = 0 AND A.ReprintNum = S.ReprintNum) AND
          (S.Sendung >= 1 AND S.Sendung <= 600)
 LIMIT    300) AS Sub;
Thanks a lot,
  Michael