Re: [GENERAL] drawback of array vs join

2009-06-23 Thread Ivan Sergio Borgonovo
On Tue, 23 Jun 2009 17:39:46 -0300 Emanuel Calvo Franco wrote: > 2009/6/23 Ivan Sergio Borgonovo : > > I've a temporary table where I'd like to resume data coming from > > several other tables (normalised the usual way). > > eg. > > a list of items that may belong to several group (eg. item, > >

Re: [GENERAL] drawback of array vs join

2009-06-23 Thread Emanuel Calvo Franco
2009/6/23 Ivan Sergio Borgonovo : > I've a temporary table where I'd like to resume data coming from > several other tables (normalised the usual way). > eg. > a list of items that may belong to several group (eg. item, > group, itemgroup table) will end up in something similar to: > > create temp

[GENERAL] drawback of array vs join

2009-06-23 Thread Ivan Sergio Borgonovo
I've a temporary table where I'd like to resume data coming from several other tables (normalised the usual way). eg. a list of items that may belong to several group (eg. item, group, itemgroup table) will end up in something similar to: create temp table itemlisttemp( lid int, iid int, qty