Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
LEFT JOIN on different data types CR10
I have 2 DB2 tables that I need to join on fields that are different data types, one is a string, the other a number. When I use a DB2 query tool, I can use the funtion "DECIMAL" to make the join work. In Crystal, I have tried many functions to get the join to work, without success. Here is...- KTTapee
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 2 Data Access
