in reply to
Merging Results from 3 different queries
It might be worth using JOIN in your SQL query to combine related tables based on their primary & foreign keys.
http://en.wikipedia.org/wiki/Join_(SQL)
just another cpan module author
Comment on
Re: Merging Results from 3 different queries
Replies are listed 'Best First'.
Re^2: Merging Results from 3 different queries
by
MegaVoice
(Novice)
on Jul 24, 2007 at 16:10 UTC
Unfortunately, I am having to use a stored procedure in the database to pivot the data just to get a single result set. I am unable to use a join inside the call to the stored procedure to return 3 the pivots that I need.
[reply]
In Section
Seekers of Perl Wisdom