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]