Kristoffer Danielsson wrote: > NATURAL INNER JOIN yields a cartesian product too. Just tried it!
Well then, *surely* that at least has to be a SQLite bug. That said, it would be useful for clarity if you posted to the list exactly how you wrote your NATURAL INNER, what the exact SQL you used was, with test data and result, so we know you didn't just make a typo in your test. Use the simplest possible example that illustrates the point, such as with Jay's example. And I would expect NATURAL JOIN to default to INNER even if JOIN defaults to CROSS, just because that makes the most sense. When people specify NATURAL, then what they expect is INNER semantics in the general case. -- Darren Duncan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users