Using JOINs

[arski]

Hi again,

There doesn't appear to be a group for discussing things in Twistar, so I ended up posting this here: Is it possible to mimic behaviour like "SELECT * FROM table1 NATURAL JOIN table2" in Twistar? Couldn't find anything like that in the documentation..

Thanks!

[bmuller]

Hey @arski - Right now, joins are only automatically produced based on relationships (and there is not a relationship right now that would mean all columns would match). Also, per the wikipedia article on joins:

Most experts agree that NATURAL JOINs are dangerous and therefore strongly discourage their use.

Is there another way to do what you're trying to accomplish?