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
>
>
>
>
>
>