How do I get queries to join non matching data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want a query to join two tables that are the same structure and are joined
by the date field, however I want it to show all the entries even when they
are not equal in either table. For example table A has the 11/11/05 and the
12/11/05. Table B has 12/11/05 and the 13/11/05. I want a query that show the
12/11/05 together but also includes a line with the 11/11/05 and the 13/11/05
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I do this date manipulation 3
How to choose only the first record from a query 4
Query with hours 1
Extracting from Crosstab query 2
Extarct Text with in string 2
How to get the max value for each date group 2
Cross Tab Query 4
Grouping - Distinct 5

Back
Top