RE: [PHP] Combining recordsets

2005-07-21 Thread Richard Lynch
On Wed, July 20, 2005 10:02 am, Shaw, Chris - Accenture said: > I recommend redesigning your query, the database can pull back the records > you want far quicker than any frontend combining/processing, since that's > what T-SQL and relational database were designed for. This is usually true, and a

RE: [PHP] Combining recordsets

2005-07-20 Thread Shaw, Chris - Accenture
[PHP] Combining recordsets * This e-mail has been received by the Revenue Internet e-mail service. * I'm wondering if someone has a better solution then I've come up with. I've got a few reports that pull from

[PHP] Combining recordsets

2005-07-20 Thread Mike Smith
I'm wondering if someone has a better solution then I've come up with. I've got a few reports that pull from various tables. Some times I'm not able to put all the tables into a single query/view. So I end up with a master query and 1 (or more) supporting queries. I'm using MSSQL 2000/IIS/PHP4/ADOD