4 Replies Latest reply: Sep 11, 2014 8:53 AM by anbu cheliyan RSS

    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?