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
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 figu
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 JOIN
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 Busi
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
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
(
6 matches
Mail list logo