Re: Unexpected results with joins on dates

> Only the first SELECT is used to define column types and names (in the case of NULL AS source2_* I am not positive if
youneed to cast the NULL or if it will use the type found in the second SELECT) and I generally put a "source" field
intothe output with a textual representation of which table the record originated from. 
>


Seems like it would be more efficient just to create a table (temp or
otherwise) with and pump data into that.

Anyway thanks for the help.