I don't think this is a bug, at least not in the context
presented. "commodities.id" really is ambiguous here, and
it can be disambiguated with "main" or "temp" or the name
of the attached database, per the documentation.
Regards
From: "Bronislav Klučka" <[EMAIL PROTECTED]>
> Hi, I've got two same databases (one is older then the second one) and I
> wanted to attach them, so I've done:
>
> attach database './database/produkty.sdb' as commodities2;
> select * from commodities left join commodities2.commodities on
>
Try main.commodities.id = commodities2.commodities.id.
See the first paragraph of www.sqlite.org/lang.html#attach.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hi, I've got two same databases (one is older then the second one) and I
wanted to attach them, so I've done:
attach database './database/produkty.sdb' as commodities2;
select * from commodities left join commodities2.commodities on
commodities.id = commodities2.commodities.id
the second query
4 matches
Mail list logo