chrisryhal
asked on
The data types text and varchar are incompatible in the equal to operator
Can run select statement because datatypes are different. I can't change datatype. Any ideas?
The data types text and varchar are incompatible in the equal to operator
The data types text and varchar are incompatible in the equal to operator
SELECT ud02.number02, customer.discountpercent
FROM customer INNER JOIN
ud02 ON customer.character01 = ud02.key1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked thanks
what is the exact error message.
what are the two field types?