On Apr 20, 2005, at 1:24 PM, Aaron Bingham wrote:
> 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