Charlie
Try
CREATE VIEW tvqino (QINo,QIName) AS +
SELECT T1.QINo, T1.QIName FROM ..........
Buddy
-----Original Message-----
From: Angela Phillips [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 3:07 PM
To: '[EMAIL PROTECTED]'
Subject: Code Error
When we try the following command the columns come up aliased as unnammed.
What are we doing wrong?
CREATE VIEW `tvqino` AS +
SELECT T1.QINo as QINo, +
T1.QIName as QIName FROM QICharter T1 +
UNION SELECT (' '+qino), ' ' +
FROM qicharter +
WHERE qino = .vQINo
Thanks,
Charlie
================================================
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/
================================================
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/
