Re: exclude columns in query

2002-07-04 Thread Egor Egorov
W., Thursday, July 04, 2002, 12:34:12 PM, you wrote: WE> is it possible to exclude columns in a query? WE> something like WE> select * from table except columnname ?? You should specify all needed columns, i.e. if your table contains 3 columns: column1, column2, column3, but you want to get d

Re: exclude columns in query

2002-07-04 Thread Dicky Wahyu Purnomo
Pada Thu, 4 Jul 2002 11:34:12 +0200 "W. Enserink" <[EMAIL PROTECTED]> menulis : > Hi all, > > is it possible to exclude columns in a query? > > something like > > select * from table except columnname ?? Nope, I don't think it's possible ... You have to give columns list, like this ... "sel