support simple fields with null table to enable complex queries