Python Forum
Join table with differnt datype column using python query
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Join table with differnt datype column using python query
#1
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.
Reply
#2
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?
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Python Alteryx QS-Passing pandas dataframe column inside SQL query where condition sanky1990 0 733 Dec-04-2023, 09:48 PM
Last Post: sanky1990
  Find a string from a column of one table in another table visedwings049 8 1,176 Sep-07-2023, 03:22 PM
Last Post: deanhystad
  list the files using query in python arjunaram 0 672 Mar-28-2023, 02:39 PM
Last Post: arjunaram
  python sql query single quote in a string mg24 1 1,066 Nov-18-2022, 08:01 PM
Last Post: deanhystad
  "SUMIF" type query in Python (help required) BlainEillimatta 0 855 Oct-06-2022, 09:08 AM
Last Post: BlainEillimatta
  Reshaping a single column in to multiple column using Python sahar 7 2,047 Jun-20-2022, 12:35 PM
Last Post: deanhystad
  MSSQL query not working in Python kat35601 0 922 Apr-12-2022, 06:44 PM
Last Post: kat35601
  pandas pivot table: How to find count for each group in Index and Column JaneTan 0 3,306 Oct-23-2021, 04:35 AM
Last Post: JaneTan
  Error using mariadb select query with form in python? shams 2 2,012 Jul-29-2021, 12:30 PM
Last Post: shams
  write mariadb table rows query to each file? shams 1 1,879 Feb-02-2021, 04:10 PM
Last Post: buran

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020