Count Joining Multiple Tables

[Kupo?]

Working on a query that I'm pretty sure is out of the scope of my skills. I've done fine thus far with simple queries contained within 1 table but I'm not sure how to go about this. Here's the pseudo-code I have currently.

Tables needed:
work_orders (column for unique_id, column for assigned tech_id)
techs (unique tech_id, tech_name)

I'm trying to get the query to list 2 columns. The first is a list of all the techs. The second is a count of all the work_orders that are assigned to their corresponding tech_id.

tech_name  wo_count
---------  -------
Jimmy      12
Bobby      23

Please let me know if more information is needed to assist. Thanks for any help.

[r937]

select tech_name
     , count(*) as  wo_count
  from techs
left outer
  join work_orders
    on techs.tech_id 
     = work_orders.tech_id
group
    by tech_name

[Kupo?]

Wow, you're awesome! Works great =]

And if you have a second... I'm all self taught when it comes to this stuff, mostly learning from debugging other peoples code and looking up things on msdn or w3c from time to time. Would you recommend anything beyond posting here when I get stuck? A book, nice manual with good examples, or any tips for learning? I'd much rather be able to do this on my own but I'm really in awe that there is a community like this to help people (beginners are people too!) out.

[r937]

check out some of the tutorials on my SQL Links page

[Kupo?]

Looks great, I'll check it out.
Thanks again!