Tuesday, 20 August 2013

MySQL join 2 columns with int type and varchar type

MySQL join 2 columns with int type and varchar type

I need make query on two tables and the columns are diffrent type. And I
can't adjust the tables. It is posible?
That is query whitsch don't work:
$query = "SELECT table1.column_content
FROM table1 OUTER JOIN table2 ON table1.int_column =
table2.varcharcolumn
WHERE (((table2.uid)=$uid))";
I need something like this:
$query = "SELECT table1.column_content
FROM table1 OUTER JOIN table2 ON CONVERT(table1.int_column,
VARCHAR) = table2.varcharcolumn
WHERE (((table2.uid)=$uid))";
Thank you TB

No comments:

Post a Comment