query problem

rockyroad · #1 (**permalink**) 10-22-05, 14:17

Could someone help me with this

I want to combine the following 2 queries into 1 query where it would give me 2 results (proflad and proftot) but don't know how

select sum(return-inv)as proflad
from allbets where com="lad"

select sum(return-inv)as proftot
from allbets where com="tot"

thanks

jfulton · #2 (**permalink**) 10-22-05, 15:28

This should work:

Code:

SELECT
(select sum(return-inv) from allbets where com="lad") as proflad
, (select sum(return-inv) from allbets where com="tot") as proftot

rockyroad · #3 (**permalink**) 10-22-05, 15:56

I tried that but I still get an error message

Error: You have an error in your SQL syntax..............

Any other ideas?

Thanks

megaultraninja · #4 (**permalink**) 10-22-05, 17:48

I believe that sub selects are supported from 4.1 and higher, so check your version.

rockyroad · #5 (**permalink**) 10-23-05, 08:47

I have version 4.0.16

Is there any way I can run this query with this?

megaultraninja · #6 (**permalink**) 10-23-05, 13:40

can you not updrade?

jfulton · #7 (**permalink**) 10-23-05, 20:32

The only other thing I can think of would be something like:

Code:

select
sum(return_inv) as return_inv, com 
from allbets 
where com="lad" OR com="tot"
group by com

but the results will be returned as two separate rows (rather than one row in two columns).

Internet Services

Web Development

Digital Marketing

Consumer Tech