wow. I really didn't know you could do it! Thanks for the syntax.

-Joe

-----Original Message-----
From: David Johnson <d_johnson@...>
Date: Monday, Jun 27, 2005 10:04 am
Subject: Re: [firebird-support] * - ?

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

On Mon, 2005-06-27 at 09:51 -0700, Joe Martinez wrote:
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
>
>
>
>



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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









++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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