SQLite Forum

Thanks, Keith.  I am trying this one that you provided with another select, 
`
sqlite> with maxes (ProjID, pl_insert, ab_insert)
   ...>   as (
   ...>       select ProjID,
   ...>              (select max(InsertDate) from Project_List where ProjID == o.ProjID) as pl_insert,
   ...>              (select max(InsertDate) from ABT_Budget where ProjID == o.ProjID) as ab_insert
   ...>         from (
   ...>               select distinct ProjID
   ...>                 from Project_List
   ...>              ) as o
   ...>      )
   ...> 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 = o.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 = o.pl_insert
   ...> WHERE a.ProjID = b.ProjID
   ...> group BY a.ProjID
   ...> ;
Run Time: real 0.031 user 0.000000 sys 0.000000
Error: no such column: o.ab_insert
sqlite> 
`
Why do I get no such column?  Thanks.

josé