Left Join Problem

mruket · July 3rd, 2009, 07:01 AM

I have two tables (say table1 and table2).

I want to left join both tables on one column (say col1 in both tables) which has varchar datatype

in table1 column(col1) has nuemeric and varchar value also
in table2 column (col1) has only numeric value

in join query i am getting error
'Conversion failed when converting the varchar value 'CHE' to data type int'

in above 'CHE' IS VALUE IN COL1 IN TABLE1

Gert · July 3rd, 2009, 07:57 AM

You can not join a varchar column with a numeric column, How ever, it should work if you convert the numeric-column to varchar in the join.