MVSFORUMS.com

[lacoe1]

In a sql how do I join these 2 types of columns ?

Table A : Col-A is defined DECIMAL ( 6, 0) NOT NULL
Table B : Col-B is defined CHAR (6) NOT NULL

Is this correct?

DECIMAL(B.COL-A,6,0,',') = C.COL-B

[lacoe1]

Sorry I did it reverse last time

In a sql how do I join these 2 types of columns ?

Table A : Col-A is defined CHAR (6) NOT NULL
Table B : Col-B is defined DECIMAL ( 6, 0) NOT NULL

Is this correct?

DECIMAL(A.COL-A,6,0,',') = B.COL-B

[kolusu]

lacoe1,

You can use