Count Key values from one table, but not all tables
I would like to count the number of distinct key value (AccountID) on one table (TableA), but not count the key values on another table (TableB). I have attached a QVW to illustrate. In TableA, there are 4 distinct AccountIDs, but when using count distinct, it returns 8, which is the distinct count across all tables that have an AccountID column. I would like to retreive the distinct count from only TableA. Any ideas?