HELP: in MySQL query

[rastaman81]

---

Mga boss, unsa-on mani siya pag-query:

"select sum(basic_pay) as regular from salary where emp_status='regular'"
"select sum(basic_pay) as contractual from salary where emp_status='contractual'"

kung usahon lang ni siya pag-query bah...help needed gyud kaayo mga ka-istoryans nga mga maayo ug sql...

thnx

[Cruzader]

same column sila?
Union gamita >_>

[cold_fusion]

The 2 sql statements are valid.

If want 2 records resuls with for each emp_status you could use:
select emp_status, sum(basic_pay) as basic_pay_sum from salary group by 1

I suggest to give more details on your problem/question. One could not guess what you really need.

[rastaman81]

bali ingon ani na ug porma sa database:
branch |employee | salary | emp_status
-------------------------------------------------------------
Cebu |Sanchez, A. | 10000.00 | regular
Davao |Yan, B. | 8000.00 | contractual
Cebu |Uy, C. | 7000.00 | regular
Manila |Martin B. | 6000.00 | contractual

=====================================
nya ang gusto unta nako, nga ang output ingon ani:
branch |regular | contractual
---------------------------------------
Cebu |17000 |
Davao |8000 |
Manila | | 6000

tabang pod mga ka-istoryans kay bag-o paman gud ko ani sql gud...thnx daan

sori, ana diay ni iya output

[rastaman81]

unsa-on mani ug paagi

tabang sad mo diha katong makamao ug mysql...

thnx

[javapenguin]

ngano ang output kay ang davao naay 8000 regular ug 8000 contractual, sa database sample 8000 contractual ra man sa davao?

[Cruzader]

"select sum(basic_pay) as regular from salary where emp_status='regular'"
"Union"
"select sum(basic_pay) as contractual from salary where emp_status='contractual'"

>_>

[rastaman81]

"select sum(basic_pay) as regular from salary where emp_status='regular'"
"Union"
"select sum(basic_pay) as contractual from salary where emp_status='contractual'"

>_>

naka try nako ani brod pero ang out put gud ani kay walay label ang naa sa ubos nga union dili siya madistinguish ug contractual ba gyud. kay ang label sa babaw regular man...

[Cruzader]

^ La man pud labels ni
Cebu |17000 |
Davao |8000 |
Manila | | 6000

Unsao gud ng klarong output

[cold_fusion]

with mysql, you could do this:

select branch, 
	sum(if(emp_status='regular',basic_pay,0)) as regular,
	sum(if(emp_status='contrctual',basic_pay,0)) as contractual
	from salary
	group by 1