Just add the additional joins:
db((db.ntw_edge.outID == 1622) & 'ntw_edge.labelID = alias_edge.labelID').
select(
join=[db.ntw_edge.with_alias('alias_edge').on('ntw_edge.inID =
alias_edge.outID'),
db.vtx_vertex.on(db.ntw_edge.inID == db.vtx_vertex.id),
db.ntw_edge_label_set.on(db.ntw_edge.labelID == db.
ntw_edge_label_set.id)])
Anthony
On Tuesday, February 20, 2018 at 3:17:21 AM UTC-5, Annet wrote:
>
> HI Anthony,
>
> Thanks for your reply.
>
>
>> What is the SQL you are trying to produce?
>>
>
>
> SELECT ...
> FROM ntw_edge
> INNER JOIN ntw_edge_alias ON ntw_edge.inID=alias_edge.outID
>
> INNER JOIN vtx_vertex ON ntw_edge.inID=vtx_vertex.id
> INNER JOIN ntw_edge_label_set ON ntw_edge.labelID=ntw_edge_label_set.id
>
> WHERE ntw_edge.outID=1622 AND (ntw_edge.labelID=alias_edge.labelID)
>
>
> I hope I provided you with sufficient information to get this part of the
> join right.
>
>
> Kind regards,
>
> Annet
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
