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
> commodities.id = commodities2.commodities.id
>
> the second query returned: "ambiguous column name: commodities.id" how can
I
> join them?
>
You need to alias one of the table names to make them unique. Try this:
select * from commodities left join commodities2.commodities as commodities2
on commodities.id = commodities2.id;
The operation of SQLite does not agree with the documentation (or expected
behavior) so you should probably file a bug report. This is really just a
workaround because the database names are not leading to unique table/column
references.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
