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.
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.
Please let me know if more information is needed to assist. Thanks for any help.Code:tech_name wo_count --------- ------- Jimmy 12 Bobby 23