I'm having trouble with what should be a really easy SQL command. I did my training over 8 years ago and use it maybe twice a year so excuse my question if this is really easy.
I have two tables. Table 1 has two relevant columns named description(varchar) and enddate(datetime) with thousands of records. Table 2 has a column named description with 700 records.
I need to update enddate with a certain date on the rows in table 1 that have a match with table 2 using the desciption column.
I thought it would be something like this:
SET tabe1.enddate = '2015-06-01 00:00:00.000'
WHERE Description IN (SELECT table1.Description
LEFT JOIN table2 on table1.Description = table2.BD
WHERE table1.Description = table2.BD)
What am I doing wrong?