Python Forum

Full Version: Join table with differnt datype column using python query
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
If I have an order table with Yearmonth in yyyymm format and datatype of the column is int.
And in another order archive table the Yearmonth is yyyymm format however the datatype is in varchar.
How do i join the table order and order archive table using the year month column which has differnt datatype using python query.
I think you need to re-read this while taking into account how readers will interpret it. Are you talking about SQL? It sounds like it, but it's impossible for us to tell.

Are you already using a module? Or are you not even that far yet?