Never mind. Sorry guys for the wasted bandwidth.
________________________________ From: sqlite-users <[email protected]> on behalf of Jose Isaias Cabrera <[email protected]> Sent: Monday, February 11, 2019 11:16 AM To: [email protected] Subject: [sqlite] Why Error: ambiguous column name: ProjID 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 _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
