I have 2 tables both have a primary key which links them,
How can I run a count query to look at the first table and check the id, then look at the second table and count up how many records have that same id?
table one
key - software_make
1 Adobe
2 Microsoft
table two
key - asset - Number_installe d
2 11454 1
2 1245 1
...