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,
> >
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
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