Hmmm, that gave me the same error.
Details: both fields are text fields and contain numbers.
ownership_number are normally 3 digit numbers that sometimes contain a letter. Examples are 100, 101, 102, 102B, etc.
Layer has the same three digit numbers with additional info usually in the case of colons. So, examples: 100:E 100:PUE, 101:ST, etc.
I just want this SQL query to work so I can modify it to narrow down my search, etc. (finding where these numbers do not match). Thanks for your help!
(Bonus, does it matter that one text field is 255 characters long and the other is 8000 characters?)