I had a select statement which selected the oldest set of data in a table with an Inner Join

```
SELECT DateAndTime
    ,Val
    ,NumIndex
    ,TagName
    ,floattable.TagIndex
FROM taglogging.floattable
INNER JOIN tagtable ON tagtable.TagIndex = floattable.TagIndex
WHERE DateAndTime = oldest;

```

This works well and does the job in returning the data set.

I want to now delete from the data set, any record where the value column is outside its min, max range which is defined in another database.

I did this

```
DELETE
FROM taglogging.floattable
WHERE Val IN (
        SELECT DateAndTime
            ,Val
            ,NumIndex
            ,TagName
            ,floattable.TagIndex
        FROM taglogging.floattable
        INNER JOIN tagtable ON tagtable.TagIndex = floattable.TagIndex
        WHERE DateAndTime = oldest
        ) < taglogging_archive.tagmembers.tagMember_minValue
    OR Val > taglogging_archive.tagMember_minValue;

```

and in doing so, got a syntax error:

```
Error Code: 1241. Operand should contain 1 column(s)

```

Does anyone see the error in my syntax :( I am new to MySQL syntax but after moving from MSSQL i was confident in the logic of my query.

Kind Regards,

Jordan