Posted by Roy Harvey on 08/20/07 20:47

It looks like you are trying to use a correated subquery without the
correlation, and without either the IN or EXISTS that makes use of
such a subquery. Perhaps this will give you some ideas.

UPDATE LastLogin
SET date = '2007-08-14 05:34:09.910',
status = 1,
activity = 0
WHERE EXISTS
(SELECT *
FROM Users u
WHERE LastLogin.userid = u.userid
AND u.email = 'dushkin@hotmail.com')

Roy Harvey
Beacon Falls, CT

On Mon, 20 Aug 2007 13:10:56 -0700, pbd22 <dushkin@gmail.com> wrote:

>
>Hi,
>
>I am trying to create an update statement
>on a table with a foreign key to the Users
>table (userid).
>
>I am getting the error:
>
>An expression of non-boolean type specified in a context where a
>condition is expected, near ')'.
>
>Below is the Update statement.
>
>UPDATE LastLogin SET
> date = '2007-08-14 05:34:09.910',
> status = 1 ,
> activity = 0
>WHERE
>(SELECT ll.status, ll.activity, ll.date
> FROM LastLogin ll, Users u
> WHERE ll.userid = u.userid
> AND u.email = 'dushkin@hotmail.com')
>
>Thanks!

[Back to original message]