Posted by solidsna2 on 02/28/06 17:22

Well I figure out the problem. I had a GROUP BY at the end of the
SELECT subquery.

UPDATE Tbl1
SET Row2 = '1'
WHERE Tbl1.Row1 = (SELECT Tbl2.Row1
FROM Tbl2
WHERE Tbl2.Row1 = Tbl1.Row1
AND CURRENT_TIMESTAMP >= Tbl2.Row3 GROUP BY
Tbl2.Row1)

Thank you again for your help.

• Next in forum: How to avoid cursors
• Prev in forum: Create New Table advice
• Thread view: Re: Error using UPDATE statement

[Reply to this message]