Hi all, I don't know if this is related to sqlite or that it is just wrong.
I want to update a column in a table with a value retrieved from the same table like this:
update mail set size = (select m1.size from mail m1 where m1.id = id and m1.sender is not null) where sender is null;
it always sets size to the first record from the query 'select m1.size from mail m1 where m1.sender is not null', it looks like it doesn't take into account the extra where clause based on the id of the record actually being updated.
anyone a suggestion ?
-- Security check and anti-virus control on this e-mail has been done by aXs GUARD (http://www.axsguard.com)
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
