Just to quantify a cartisian join is a join operation that returns the product
of the rows. So in the example given
episodes 8
foods100
food_episodes 800
episodes e1, foods_episodes fe1, foods f, episodes e2, foods_episodes fe2
Result rows = 8*800*100*8*800 = 4,096,000,000 rows... (ov
On Mar 21, 2008, at 12:17 PM, Derek Developer wrote:
> In trying to break my code with the seinfeld database examples, I
> found this.
> SELECT f.name as food, e1.name, e1.season, e2.name, e2.season FROM
> episodes e1, foods_episodes fe1, foods f, episodes e2,
> foods_episodes fe2
> Why doe
On 3/21/08, Derek Developer <[EMAIL PROTECTED]> wrote:
> In trying to break my code with the seinfeld database examples, I found this.
Derek,
You are going to get much better help from the list, not to mention
that you will probably get further with your "code breaking," if you
provide some more
In trying to break my code with the seinfeld database examples, I found this.
SELECT f.name as food, e1.name, e1.season, e2.name, e2.season FROM episodes e1,
foods_episodes fe1, foods f, episodes e2, foods_episodes fe2
Why does this put SQLite into an endless loop?
(I am not using the shell tool,
4 matches
Mail list logo