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/
