SQLite Forum

Any reason not to use a three-way join?

<pre>
    select count(*)
    from edge,
        temp.sub_nodes src on src.node_id=node_from,
        temp.sub_nodes dst on dst.node_id=node_to;

</pre>