[SQL] Possible to use a table to tell what table to select from?

2005-07-13 Thread Frank Hagstrom
Hello I've been thinking on a potential problem I might get in a distant future, but once I started thinking on it I just as well had to check... Is it possible to have say ~ 6 tables, where the first one is a 'reference' to all the others (they all are with the same structure). The other 5 or so

Re: [SQL] Possible to use a table to tell what table to select from?

2005-07-14 Thread Frank Hagstrom
On 7/14/05, Richard Huxton wrote: > Frank Hagstrom wrote: > > Hello > > > > I've been thinking on a potential problem I might get in a distant > > future, but once I started thinking on it I just as well had to > > check... > > > > Is it possibl