How to join 2 queries in Python

Question

I am in Python and I have the above 2 queries which I want to join them in 1.

def fly_away(session, line_id):
    query = session.\
              query(
                Pilot.Id,
                Pilot.EntityId,
                Pilot.From
              ).\
    filter(Pilot.Id == line_id)

    query = session.\
                  query(
                    CTower.Id,
                    CTower.Time,
                    CTower.Associate
                  ).\
    filter(CTower.Associate == line_id)

I tried to use join but I dont know how to use it correctly. Can I have some help please?

The query makes no sense to me. Please, show us how the data looks like and what are you trying to get from it. — khajvah
– khajvah, Commented Mar 9, 2015 at 9:08
The queries in my question are 2. I want to join them. I want to get data from two different tables .. with one query.. the data and the tables are written on my question. — Give IT
– Give IT, Commented Mar 9, 2015 at 9:12

khajvah · Accepted Answer · 2015-03-09 09:39:18Z

1

I don't know what database are you using and what driver are you using to connect python to the database but I will post the sql query that will do the job. I am sure, you can use it with your driver.

SELECT Pilot.Id, Pilot.EntityId, Pilot.From, CTower.Id, CTower.Time, CTower.Associate 
FROM Pilot, CTower 
WHERE CTower.Associate == Pilot.Id

edited Mar 9, 2015 at 9:39

answered Mar 9, 2015 at 9:33

khajvah

5,1009 gold badges44 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

khajvah Over a year ago

@TakisMakis What is session object?

Give IT Over a year ago

its something irrelevent on how to join these two queries.

khajvah Over a year ago

@TakisMakis Well, I have joined those two queries as you can see from my answer, if that is what you want. If you want to run it in python, you should give more info about stuff you use.

Give IT · Accepted Answer · 2015-03-11 09:35:15Z

0

def fly_away(session, line_id):
  query = session.\
          query(
            Pilot.Id,
            Pilot.EntityId,
            Pilot.From,
          ).\
          outerjoin(CTower, Pilot.Id == CTower.Associate).\
          filter(Pilot.Id == line_id)     
  return query

this is what I am trying now.. and its working .. but not exactly as I want

edited Mar 11, 2015 at 9:35

answered Mar 9, 2015 at 11:30

Give IT

2001 gold badge3 silver badges19 bronze badges

Collectives™ on Stack Overflow

How to join 2 queries in Python

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related