Hello,

Does anyone in this forum can help me in joining two tables with one table having a field as "serial" datatype and another table having a field as "charater" datatypes.

Thank you in advance.

Bdhakhwa, Nepal

The database server should convert character column to numeric column(or vice-versa) automatically using built-in casts.
In my case it works.
Check your character column if it contains any characters that are not valid numbers.