SQL COUNT - detail record count on header records

["Patrick L Archibald" <Patrick.Archibald@xxxxxxxxxxxxx>]

Hi

I've racked my brains and searched high and low.
I can't find the correct SQL SELECT statement to 
count the number of records in a detail file and 
show that count in my header record. 

The following SELECT statement gives me what I want
except I want to see zero in the count field if 
there are no matching records in the detail file. 

select a.*, b.count from som.som022clsd as a, (select phonenum,        
ordrnmbr, count(*) as count from som.sompfa21 group by phonenum,       
ordrnmbr) as b where a.phonenum = b.phonenum and a.ordrnmbr =      
b.ordrnmbr and a.conumber = '08' and a.workdate between 20010301   
and 20013030                                                       

Previously I wanted to sum a total in a detail file and show 
it along the header fields but couldn't figure that out either. 
Again I want to show zero in the sum field if there are no 
matching records in the detail file. 

Can someone please point me in the right direction?

Thanx, PLA
/ 
/ Patrick L Archibald
/ http://HomeTelco.com/pla/
/
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---