it works correctly. I had originally made it *join(n2, d2.node)*, but
received an error saying *table name "anon_2" specified more than once*.
Like you said, it should have read like the original SQL statement and I
was trying to join n2 twice.
Thanks again,
SB
--
SQLAlchemy -
Th
In my last code block I have a hard-coded drawing_id of 7 from a bad
copy/paste, but this would just be the DrawingNode's drawing_id.
On Thursday, May 25, 2017 at 11:28:48 AM UTC-5, SB wrote:
>
> I'm using SQLAlchemy in Flask and I'm trying to map a relationship between
&g
ode_2.id
INNER JOIN dn_1 AS dn_2 ON dn_2.node_id=node_2.id AND dn_2.drawing_id=dn_1.
drawing_id
WHERE dn_1.drawing_id=7;
2. In Drawing, modify "drawing_nodes" such that it also joins the
information from that DrawingNode's Node in the relationship. I'm less
concerned about this one
some_id
What is the most straight forward approach to do so.
Thanks, sb.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com