Re: Selecting columnnames from other table
From: Joel Garry <joelga_at_rossinc.com>
Date: 1996/12/05
Message-ID: <1996Dec5.225044.17010_at_rossinc.com>#1/1
Date: 1996/12/05
Message-ID: <1996Dec5.225044.17010_at_rossinc.com>#1/1
In article <586ag1$qrk_at_charm.il.ft.hse.nl> roger_at_il.ft.hse.nl (Roger Palmen) writes:
>I want to select a number of columns from a database. (well, isn't that what
>databases are about?) The columnnames which I want to retrieve are specified
>in another table.
>
>
>Anybody an idea?
>
>Roger Palmen roger_at_il.ft.hse.nl
If you are on unix you could select from the table of columnames into a spooled file, then use unix utilities to clean it up and make a nice sql command file out of it.
-- Joel Garry joelga_at_rossinc.com Compuserve 70661,1534 These are my opinions, not necessarily those of Ross Systems, Inc. <> <> %DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push. \ V / panic: ifree: freeing free inodes... OReceived on Thu Dec 05 1996 - 00:00:00 CET