My suggestion would be to create a temp table of the attributes (attrID and value) from the tblSearchCr table (ignoring non supplied entries). Count the number of rows in that table (for use see later). Left Join this table to each attrSFloat, attrRFloat and attrString table and assuming attrID can only exist in one of those tables, count the number of rows where at least one one of attrSFloat, attrRFloat and attrString is not null and match that count to the count of rows in the temp table.