Charlie/Angela,
Use the SQL CREATE VIEW syntax for aliasing, rather than the
SELECT syntax that aliases one column at a time:
CREATE VIEW `tvqino` (QINo, QIName) AS +
SELECT T1.QINo, +
T1.QIName FROM QICharter T1 +
UNION SELECT (' '+qino), ' ' +
FROM qicharter +
WHERE qino = .vQINo
Bill
On Thu, 18 Jul 2002 14:06:48 -0500, Angela Phillips wrote:
>When we try the following command the columns come up aliased
as unnammed.
>What are we doing wrong?
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
