I want to do a remote view and link tables on Vendor_number, however Vendopr_number in one table is Character 9 and it is an INT in other table.

How do you join tables on different data types?

table a Fields invoice_num, char 20 Vendor_number Char 9

Table b Fileds Vendor_number INT vendor_name Chr 35

I am trying to do a view that shows a.Invoice_num and b.Vendor_name