1

There's a question how to generate sql expression like

select a,b from a left join b on (a.id = b.aid and b.aid = 12)

in sqlalchemy...

I tried with

session.query(a.id, b.id).outerjoin(b, a.id == b.aid and b.aid == 12)

but did not got the right result...

is this feasible in sqlalchemy? ?

Ilja Everilä
  • 50,538
  • 7
  • 126
  • 127
lsxwd1235
  • 11
  • 2

0 Answers0