You can can't you ?



Select s.*, c.custfname, c.custlname

From

Sales s

Join customers c on c.custref = s.custref

......



Martin



________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Joe Martinez
Sent: 27 June 2005 17:51
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] * - ?



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 your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe

>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



________________________________



[Non-text portions of this message have been removed]