Re: [sqlite] Why Error: ambiguous column name: ProjID

2019-02-11 Thread Jose Isaias Cabrera
Simon Slavin, on Monday, February 11, 2019 11:53 AM, wrote... >On 11 Feb 2019, at 4:51pm, Jose Isaias Cabrera wrote: > >> Thanks. Yes, sometimes I should revise 3 or 4 times before asking. :-) As >> soon as I sent it, I figured it out. > >It wouldn't help. You can read it ten time, rewrite it

Re: [sqlite] Why Error: ambiguous column name: ProjID

2019-02-11 Thread Simon Slavin
On 11 Feb 2019, at 4:51pm, Jose Isaias Cabrera wrote: > Thanks. Yes, sometimes I should revise 3 or 4 times before asking. :-) As > soon as I sent it, I figured it out. It wouldn't help. You can read it ten time, rewrite it three times, and explain it to your pet duck. You still won't

Re: [sqlite] Why Error: ambiguous column name: ProjID

2019-02-11 Thread Jose Isaias Cabrera
J. King, on Monday, February 11, 2019 11:25 AM, wrote... >On February 11, 2019 11:16:32 AM EST, Jose Isaias Cabrera >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

Re: [sqlite] Why Error: ambiguous column name: ProjID

2019-02-11 Thread J. King
On February 11, 2019 11:16:32 AM EST, Jose Isaias Cabrera 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

Re: [sqlite] Why Error: ambiguous column name: ProjID

2019-02-11 Thread Jose Isaias Cabrera
Never mind. Sorry guys for the wasted bandwidth. From: sqlite-users on behalf of Jose Isaias Cabrera Sent: Monday, February 11, 2019 11:16 AM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Why Error: ambiguous column name: ProjID This SQL

[sqlite] Why Error: ambiguous column name: ProjID

2019-02-11 Thread 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