Question
SQL Query - Joining 2 Recordsets to display all columns requested
Hi
I'm trying to join two SQL SELECT Statements to output the information into a table on a html page.
They both query the same table maccount but on different selection criteria
here are the two statements below
SELECT muser, COUNT(status) * 40 / 35 AS Expr1
FROM maccount
WHERE ((status <> '0')) GROUP BY muser
SELECT muser, COUNT(status) * 60 / 35 AS Expr2
FROM maccount
WHERE ((status = '1')) GROUP BY muser
I need to join these to give me three colums, muser, Expr1, Expr2
Any ideas? I've run out!!!!
Thanks for any help!!!
I'm trying to join two SQL SELECT Statements to output the information into a table on a html page.
They both query the same table maccount but on different selection criteria
here are the two statements below
SELECT muser, COUNT(status) * 40 / 35 AS Expr1
FROM maccount
WHERE ((status <> '0')) GROUP BY muser
SELECT muser, COUNT(status) * 60 / 35 AS Expr2
FROM maccount
WHERE ((status = '1')) GROUP BY muser
I need to join these to give me three colums, muser, Expr1, Expr2
Any ideas? I've run out!!!!
Thanks for any help!!!
