I need some basic help that I am just not able to solve myself. I am so new to SQL that I am sure that I am my own worst enemy.
We have a large data set that has a number of fields including data time. This is not a calculated field but rather a "time" field that is populated through an upload of data. It is not part of date/time but just the time field.
I want to delete records where the data time is equal to: 19:45:33 and the WHOLEID is equal to 83-SW. Seems easy enough but I continue to get a boolean error near "time". I don't know what I am doing wrong but would appreciate the help.