SQLite Forum

Error: no such column: x
Login
Greetings!

Please take a look at the following query:

`WITH maxes(ProjID, pl_insert, ab_insert)
as (
      SELECT 
        ProjID,
        MAX(InsertDate),
        (select max(InsertDate) from ABT_Budget where ProjID = e.ProjID)
        FROM Project_List e
    group by ProjID
   )
SELECT a.*,sum(b.AnnualDossier) as Dossier FROM Project_List AS a 
LEFT JOIN ABT_Budget AS b ON a.ProjID = b.ProjID
AND
    b.InsertDate = e.ab_insert
AND
  a.PMO_Board_Report != 'No' 
  AND
  (
      (
        a.Target_Go_Live_Date > substr(date('now'),1,4) || '-01-15'
      )
      OR
      (
        a.Target_Go_Live_Date = '' AND a.Finish_Date >  substr(date('now'),1,4) || '-01-15'
      )
  )
  AND
  a.InsertDate = e.pl_insert
group BY a.ProjID;
`

And if I execute this command,

`
sqlite> WITH maxes(ProjID, pl_insert, ab_insert)
   ...> as (
   ...>       SELECT
   ...>         ProjID,
   ...>         MAX(InsertDate),
   ...>         (select max(InsertDate) from ABT_Budget where ProjID = e.ProjID)
   ...>         FROM Project_List e
   ...>     group by ProjID
   ...>    )
   ...> SELECT * from maxes;
ProjID|pl_insert|ab_insert
PR0000003811|2019-02-12_12-12-12|
...clip...
`

Why do I get no such column?  Any help would be greatly appreciated. Thanks.

josé