- see footer for list info -<
Get them both from the db at the same time and use UNION.
On 12/17/06, Lee Fortnam <[EMAIL PROTECTED]> wrote:
>- see footer for list info -< Firstly, Will apologies for typing this email after returning from a night out, however, something has been annoying me. I have 2 similar queries that return records from tables which differ slightly depending on whether something is voice or SMS based. Anyway, currently I run 1 query for the SMS info and 1 query for the voice info. At present these are displayed in 2 tables, I now need to combine the results in 1 table based on the results of both queries. Both queries have the same result fields but need to rank them accordingly. Dare say it is something to do with query of queries etc but brain dead at mo! Regards, Lee Fortnam _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
-- Simon Baynes www.simonbaynes.com _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< - Lists hosted by www.Gradwell.com -< - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
