Re: Union Query Long Datatypes and a "Placeholder" Corresponding Value

On Mon, 23 Jan 2006 01:13:49 -0330, Tim Marshall wrote:

> However, I have one
> case where c2 is a long data type in one table and there is nothing
> corresponding in the second table (it does not have a long datatype
> column). Is there a way to handle this?

What's exactly the purpose of your query in this specific case? If the second c2 is not important, can't you use something like this:

select c1,c2,null from ... union all select c1,null,c2 from ... ? Received on Mon Jan 23 2006 - 04:00:41 CST