J. King, on Monday, February 11, 2019 11:25 AM, wrote... >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. > >"...WHERE ProjID IN..." > >Which ProjID, a or b?
Thanks. Yes, sometimes I should revise 3 or 4 times before asking. :-) As soon as I sent it, I figured it out. Thanks. josé _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
