Pulling counts from two tables using a third as primary key

Viewed 25

I have a business unit table with business unit number in it. I have two separate tables that I am pulling counts of different issues from. I would like to end up with a table that has three columns: Business unit number, count of issue 1, count of issue 2.

Example:

2344     4      null
2345     null   2
2346     2      3
0 Answers
Related