Here's what I wish was possible... I want to grab ALL the fields in one
table, and only a couple of fields in a joined or subselected
table. Something like:

Select * from sales, custfname,custlname from customers...

-Joe

At 09:45 AM 6/27/2005, you wrote:

>No.
>
>On Mon, 2005-06-27 at 11:42 -0500, Clay Shannon wrote:
> > Is there some kind of syntax in SQL which allows you to select most of the
> > columns from a table without selecting them all.
> >
> > IOW, if you have a table with 25 columns, and you want 22 of them in your
> > result set, can you do something like:
> >
> >
> >
> > Select (* - SuperfluousVal, SuperfluousVal2, SuperfluousVal3) from .
> >
> >
> >
> > .rather than explicitly listing the 22 columns?
> >
> >
> >
> > Listing the 22 columns explicitly is a pain; grabbing all 25 using "SELECT
> > *" is wasteful.
> >
> >
> >
> > Clay Shannon,
> >
> > Dimension 4 Software
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>