I have a query and a table that I need to join. The table is called Associates and has asKey asFirstName, and asLastName. The query is called JoinAssoc and has Associd which needs to be joined with Associates.asKey. I also need this new query to have SlDate and SalesCount from Query JoinAssoc. It would also be great if I could join the asFirstName and asLastName into one column.