I have the following sql statement and I get a "cannot be bound" error.
set a.sizeenglish= b.sizeenglish
from Products a , Conversions b
where b.sizedecimal= a.sizedecimal
the conversion table looks like this
2 3/4", 5.625
the decimal sizes in my products table are already populated.