![Microsoft Access Not-In Query SQL Tip: Finding Records in One Table but Not Another with Outer Join Queries Microsoft Access Not-In Query SQL Tip: Finding Records in One Table but Not Another with Outer Join Queries](https://www.fmsinc.com/microsoftaccess/query/outer-join/Query0-Design.jpg)
Microsoft Access Not-In Query SQL Tip: Finding Records in One Table but Not Another with Outer Join Queries
![Understanding Join Properties: IU Only: Files: Access: Structuring and Relating Data: All Training Topics: UITS IT Training Content Library: Indiana University Understanding Join Properties: IU Only: Files: Access: Structuring and Relating Data: All Training Topics: UITS IT Training Content Library: Indiana University](https://ittrainingcontent.iu.edu/training/accsd/files/pc/img/img_leftOuterJoinQD1.png)
Understanding Join Properties: IU Only: Files: Access: Structuring and Relating Data: All Training Topics: UITS IT Training Content Library: Indiana University
![MS Access: how to create joins to avoid "cannot add record(s); join key of table...not in recordset" error - Super User MS Access: how to create joins to avoid "cannot add record(s); join key of table...not in recordset" error - Super User](https://i.stack.imgur.com/TzUhr.jpg)