use a union query instead of a join to simplify the data results