[sqlite] Why Error: ambiguous column name: ProjID

[Jose Isaias Cabrera]

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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users