query based on 3 other queries

[rascal]

I have 3 queries: query 1 has date, agent and # of calls fields, query 2 has
date, agent and # of accounts worked fields, query 3 has date, agent and # of
records worked. I have tried to build a query that will join all of them
together. THe query would have date, agent, # of calls, # of accounts worked
and # of records worked fields. However for any particular not all agents
will have records in all of the queries. For example in query 1 not all
agents will have records for any particular date in the other 2 queries for
that particular date, and the same holds true for the other 2 queries. Any
suggestions on how to get this query to work would be most appreciated.
thanks

 

[KARL DEWEY]

First create a union query to build a complete list of date & agent. Then
left join it to the other three queries.