inner join

Question

hello,

there is a value in one of the columns.

for example:

table1.column1 --> 11506.8

in another table2.column2, there is a value for example:

column2 --> 11506.80

In the inner join transaformation, as per business I have to do an inner join to join table1.column1 == table2.column2

But there is no match

any suggestions?

thank you

Answer 1

Hi @arkiboys

Thank you for reaching out to the community forum with your query.

Based on your query, it seems like there is a mismatch between the values in table1.column1 and table2.column2 when performing an inner join. One possible reason for this could be the difference in the data types of the columns. For example, table1.column1 might be of type float while table2.column2 might be of type decimal. In such cases, the values might appear to be the same, but the data types are different, causing the inner join to fail.

To resolve this issue, you can try converting the data types of the columns to match each other before performing the inner join. For example, you can try converting table1.column1 to decimal using the CAST function and then perform the inner join. Here's an example query:

SELECT *
FROM table1
INNER JOIN table2
ON CAST(table1.column1 AS decimal(10,2)) = table2.column2

This query converts table1.column1 to a decimal data type with a precision of 10 and a scale of 2 before performing the inner join. You can adjust the precision and scale values based on your specific requirements.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.