tions into
> query.join(bus1_alias, ).
>
>
>
>
>
> On 04/03/2017 04:53 PM, Jason T. wrote:
> > Okay. I figured out how to use the ORM without joins, but I still can't
> > figure out how to use the joins. :(
> >
> > bus1_alias =
ilter(bus1_alias.number == bus1). \
filter(bus2_alias.number == bus2).first()
On Monday, April 3, 2017 at 1:29:49 PM UTC-5, Jason T. wrote:
>
> All,
>
> I am able to join two tables and get the desired result with the below SQL
> syntax; however, I am having trouble translating this SQL to th
All,
I am able to join two tables and get the desired result with the below SQL
syntax; however, I am having trouble translating this SQL to the ORM join
syntax. Any help will be appreciated.
SELECT *
FROM raw.branch as b
JOIN raw.bus AS bus1
ON bus1.id = b.id_from_bus
AND bus1.id_model
