Join? Append?

[pickslides]

Hi AWF crew, hope you are all well.

I have this problem with a query. I have 2 tables, a primary table I want to keep complete and a secondary table that has some information I want to add to some of the records in my primary table.

When runnig a normal join type query some of the records in my primary table disapear because there is not a matching ID in the second table.

What I need to do is only add this additional info (which is a date) to the primary table in some of the records matched to the secondary table.

I have attached a really simple spreadsheet that will explain it better.

 

[boblarson]

You just need an outer join where you set the join to select all records from table1 and only those records from table2 that match.

If you join on the ID field and then double-click on the join line it will open those options for you.

 

[pickslides]

Worked very nicely, thanks a million!

 

[gemma-the-husky]

one point

iis this a one-to-one join - ie is there only ever one record in the associated table - if so, there is normally no need for separate tables, as all the information can be included in the main table, and it is a lot more efficient for you - there are only normally some fairly specialized needs for 1-1 joins.

 

[pickslides]

one point

iis this a one-to-one join - ie is there only ever one record in the associated table - if so, there is normally no need for separate tables, as all the information can be included in the main table, and it is a lot more efficient for you - there are only normally some fairly specialized needs for 1-1 joins.

Thanks Gemma, point taken. These 2 tables were from separate databases.