When running the below query SQL reports back saying "Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to numeric."
a.first_name as First_Name
,a.last_name as Last_Name
,a.e_mail as E_Mail
,b.trans_no as Transaction_Number
from guests a
trs_info b on
a.guest_no = b.trans_no
transact c on
b.trans_no = c.item
The table trs_info, column trans_no is all numeric, such as "2100200" whereas the table transact, column item is either numbers, such as "15:30" is varchar (mix of numbers or words\letters).
Any help is greatly appreciated!