HI, I am creating the join by using the query builder where as my source tables both are directly reading from DB as one of the table join column is not matching (data type) with other table join column , where as i know eg programming while joining in proc sql we can convert to numeric(input) and join the tables but here the problem is we are reading from db in query builder and joining.The error saying data type not matching on the join column. any ideas with out locally creating and coNverting the column , i want to do directly in query builder join even if data type is different .
... View more