> 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]

Reply via email to