On February 11, 2019 11:16:32 AM EST, Jose Isaias Cabrera <[email protected]> wrote: > >This SQL, > > SELECT a.*,b.*,c.Area,d.Bus_Area FROM Master_Project_List AS a > LEFT JOIN Master_Project_List_Extra AS b ON a.ProjID = b.ProjID > LEFT JOIN Bus_IT_Areas_ORGs AS c ON a.IT_OBS = c.IT_OBS > LEFT JOIN Business_OBS_List AS d ON a.Business_OBS = d.Bus_OBS > WHERE ProjID IN > ( > SELECT ProjID FROM Master_Project_List WHERE ProjID = 'PR0000011894' > ) > > ORDER BY ProjID; > >is returning the error, > >Error: ambiguous column name: ProjID > >using SQLite version 3.26.0 2018-12-01 12:34:55. > >_______________________________________________ >sqlite-users mailing list >[email protected] >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
"...WHERE ProjID IN..." Which ProjID, a or b? -- J. King _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
