create table a (foo varchar); insert into a (foo) values ('baz'); create table b (foo varchar); insert into b (foo) values ('woof'); select '"' || foo || '"' as foo from (select foo from a) as bar union select foo from b;
No, it's doing what you asked.
You mean:
select '"' || foo || '"' from (select foo from a union select foo from b) as subq;
Right?
-Kevin
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
