RE: [sqlite] Update question

[Samuel R. Neff]

Try this:

UPDATE items
SET price = (
        SELECT price
        FROM month
        WHERE id = items.id)
WHERE id IN (SELECT id from month);
 
HTH,

Sam


-------------------------------------------
We're Hiring! Seeking a passionate developer to join our team building
products. Position is in the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]
 
-----Original Message-----
From: Cesar Rodas [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, March 07, 2007 2:53 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Update question

Hello to all  I want to know if sqlite supports updates to more than a
table, as mysql allows

Ex:

UPDATE items,month SET items.price=month.price
WHERE items.id=month.id;

Thanks to all


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------