REPOST - Wildcard aliases

Is there a way to do <snip>SELECT table.* AS alias.*</snip>, or do I
have to write additional code to automate the process?

This message was reposted because it had expired, even though it was
only up for less than an hour, and disappeared along with the excellent
response that I had received to it.
--

Regards,

Jeff Gardner
___________________________

"Contrary to popular belief, Unix is user friendly. It just happens
to be very selective about who its friends are." --Kyle Hearn

Jeff Gardner wrote:
> Is there a way to do <snip>SELECT table.* AS alias.*</snip>,

No.

> or do I
> have to write additional code to automate the process?

Yes.

Regards,
Bill K.

Jeff Gardner wrote:
> Is there a way to do <snip>SELECT table.* AS alias.*</snip>, or do I
> have to write additional code to automate the process?
>
> This message was reposted because it had expired, even though it was
> only up for less than an hour, and disappeared along with the excellent
> response that I had received to it.

Usenet messages don't expire. They are around forever. You can find
postings in archives from 15 years ago. And I can still see your old
message and the response.

Check your newsreader settings. Or look at the Google Groups archive of
his newsgroup.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Peter H. Coffin wrote:
> How is what you are asking for different from
>
> SELECT * FROM MYTABLE MYALIAS
> WHERE MYALIAS.COLNAME = 'value';

Table names and Aliases are not normally added to column labels. That
is, when you use the query above, assuming MYTABLE has columns a, b, c,
you get a result set back columns with labels a, b, c. You don't get
mytable.a, mytable.b, mytable.c, nor do you get myalias.a, myalias.b,
myalias.c.

I interpreted the OP's question that he wanted the table name included
in the label.

Regards,
Bill K.