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
On Tue, 20 Jul 2004 10:15:58 -0400, Dave Watts <[EMAIL PROTECTED]> wrote:
> > if you wanted to take two queries, with like columns, and
> > data that needed to be merged, what would you do?
> >
> > 1. turn the query record set into a structure, and find the
> > matching keys, and merge the data?
> > 2. turn the query record set into an array and do the same
> > kinda thing?
> > 3. or some other way?
> >
> > just wondering. im leaning towards making it a structure,
> > and manipulating that way.
>
> Why not use Query-of-Query functionality?
>
> SELECT ... FROM q1
>
> UNION
>
> SELECT ... FROM q2
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> phone: 202-797-5496
> fax: 202-797-5444
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
