ratingDate
assigned to one of their rating's, and let's assign it a value.User
relation and for each individual user, it will check for their uID
in the Review
table, and if the ratingDate
returns true for ISNULL
, then it will return that user in the end result.uID
of 207 and 202 respectively.ratingDate
for these two individuals in the Review
table. We would have to edit our query a little bit and have it look like this:UPDATE
statement, and we're telling SQL to UPDATE
the Review
table. Find all the users with a uID
that satisfy the subquery in the WHERE
clause, but only consider reviews that currently have no ratingDate
. Then take the ratingDate
for those reviews and give it a value of '2014'
. We'll assume we don't know the exact date that they rated the movie, but we know it was in 2014.