Try casting the data to the appropriate type in each of the queries then use
QoQ with UNION... Should get you what you need. And go punch the DB designer
in the nose :-)

Mike T

> dont ask, but its a bad db design, not me, and there are some
> text cols, that prevent that!!!!!!!!!!! and the two db's dont
> have the same cols, dont ask, its annoying, but mike t
> suggested on aim, to use cast, and maybe that'll work??
>
> tw
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to