RE: column_name

2001-08-22 Thread Don Read
On 22-Aug-2001 Jeremy Morano wrote: > Hi , > > I was wondering if there was a way to retreive a column_name instead of a > value in an sql select query? > > For example if my table has the fieldfirstname, lastname, telephone, > movie1, movie2, movie3.. > > > And my first record is

Re: column_name

2001-08-22 Thread Ian Barwick
On Wednesday 22 August 2001 16:48, Jeremy Morano wrote: > > I was wondering if there was a way to retreive a column_name instead of a > value in an sql select query? > > For example if my table has the fieldfirstname, lastname, telephone, > movie1, movie2, movie3.. > > > And my first reco

Re: column_name

2001-08-22 Thread John Meyer
At 10:48 AM 8/22/01 -0400, you wrote: >For example if my table has the fieldfirstname, lastname, telephone, >movie1, movie2, movie3.. You haven't done a good job of database normalization. Those movies should be broken out to their own table. Onto what you were talking about, I kno