CODEWITHSUNDEEP
pythonsqlalchemy
Arslan Haider Sherazi
Arslan Haider Sherazi

Reputation: 69

How to use from table without specifying in query() in sqlalchemy?

following is my code for sqlalchemy inner join. I dont want to select any column of Order table but also I need Order as my from table.

query = db.session.query(Order, Customer.first_name, Customer.cnic_no, Item.name, Item.category)
query = query.join(Customer)
result = query.join(Item)

Upvotes: 4

Views: 211

Answers (1)

Ehsaan Israr
Ehsaan Israr

Reputation: 637

Use select_from

query = db.session.query(Customer.first_name, Customer.cnic_no, Item.name, Item.category)
query = query.select_from(Order)
query = query.join(Customer)
result = query.join(Item)

Upvotes: 3

Related Questions