Python Forum
Join table with differnt datype column using python query - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Join table with differnt datype column using python query (/thread-23598.html)



Join table with differnt datype column using python query - abhishek6555 - Jan-07-2020

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.


RE: Join table with differnt datype column using python query - micseydel - Jan-07-2020

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?