General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Join on different data types
Environment versions
Network:
Windows 2000 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only