I'm using two tables to make a table through a make table query. The problem I'm having is that I'm not selecting all the recods from the second table. Both tables are joined on course #. But if a course # is in table 1 and has a match in table 2 I get both records. But if I have a course # in table 2 and not in table 1 I do not get that record. I used the standard join properties but they only offer all from one tabel and only matches from the other table. Is there a way to query and get all records from both tables. Because I need to build a record that has data from both table if I get a match by course #. If no match still create a record.
Start Free Trial
