Join.

neiljchen · #1 (**permalink**) 02-27-04, 01:55

select e.dname, count(e.sid) as total_num from enroll e
group by e.dname

select e.dname, count(e.sid) as "major_enroll"
from enroll e, major m
where e.sid = m.sid and e.dname = m.dname
group by e.dname
-----------------------------------------------------------------------
Hi, buddys,
How can I join above two results of queries by dname if I don't have any create temporary table permission???

Thx,

Neil

Littlefoot · #2 (**permalink**) 02-27-04, 02:20

PHP Code:


			
select e.dname, count(e.sid) as total_num 

from enroll e 

group by e.dname



UNION



select e.dname, count(e.sid) as "major_enroll" 

from enroll e, major m 

where e.sid = m.sid 

  and e.dname = m.dname

group by e.dname;

It works with Oracle ...

neiljchen · #3 (**permalink**) 02-27-04, 04:56

Quote:

Originally posted by Littlefoot

PHP Code:


			
select e.dname, count(e.sid) as total_num 

from enroll e 

group by e.dname



UNION



select e.dname, count(e.sid) as "major_enroll" 

from enroll e, major m 

where e.sid = m.sid 

  and e.dname = m.dname

group by e.dname;

It works with Oracle ...

neiljchen · #4 (**permalink**) 02-27-04, 04:58

I don't need to union set, I mean.
I want total_num and major_enroll are two columns in the same table.

thx.
neil

Quote:

Originally posted by Littlefoot

PHP Code:


			
select e.dname, count(e.sid) as total_num 

from enroll e 

group by e.dname



UNION



select e.dname, count(e.sid) as "major_enroll" 

from enroll e, major m 

where e.sid = m.sid 

  and e.dname = m.dname

group by e.dname;

It works with Oracle ...

Internet Services

Web Development

Digital Marketing

Consumer Tech