n00b needs help combining queries...

[SCRUBBIE1]

I have several queries I need to combine if possible. I think it would make displaying the results easier. Also, doing them one at a time doesn't allow me to display the results in the order I want them. Anyway, here are the queries.

SELECT salesperson FROM salesdemo WHERE month=$mo AND salesperson=$sp

SELECT COUNT(deal_id) AS num_sales FROM salesdemo WHERE month=$mo AND salesperson=$sp

SELECT COUNT(deal_type) AS num_fin FROM salesdemo  WHERE (deal_type='finance' OR deal_type='lease') AND month=$mo AND salesperson=$sp

SELECT COUNT(VSC) AS num_vsc FROM salesdemo WHERE VSC != '0.00' AND month=$mo AND salesperson =$sp

SELECT COUNT(etch) AS num_etch FROM salesdemo WHERE etch != '0.00' AND month=$mo AND salesperson=$sp

SELECT SUM(tot_front) AS front, SUM(fin_in) AS back,SUM(tot_in) AS profit FROM salesdemo WHERE month=$mo AND salesperson=$sp

if it needs it, GROUP BY salesperson

any help appreciated!! Cori

[Thora_Fan]

I believe UNION or JOIN is what you need to look into.

http://dev.mysql.com/doc/mysql/en/union.html

http://dev.mysql.com/doc/mysql/en/join.html

For the problem with displaying the results in the order you want, check the ORDER BY syntax.

http://dev.mysql.com/doc/mysql/en/sorting-rows.html

Of course, this is assuming that you are using MySQL.

[SCRUBBIE1]

Thank you! Its hard to find what I'm looking for cuz I don't know what its called! I'll check out the articles today.
Cori

[SCRUBBIE1]

Moved to new question..