I have two tables. Lets say A and B. I need to join the two tables and return the count from table be.
So an example
B.FID (This is the relationship to A.ID)
So I would want something like
A.ID, A.F1, A.F2, Count(BFID)
I have an export process and the data in table B indicates what is held up. So this is helpful for the engineers when they are troubleshooting issues with what is hung if the count is not 0. Table A indicates the accounts.