Re: [sqlite] Sub-Select

[Jakub Adamek]

Michael, it is because SQLite 3.1.3 changed (or has errors in, it is a 
matter of opinion) the column naming. Try

>> SELECT   max(Sendung)
>> FROM
>> (SELECT  S.Sendung AS 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;
Michael Knigge wrote:
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