|
|
Posted by pbd22 on 08/20/07 20:10
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!
Navigation:
[Reply to this message]
|