Query Joins
in [Queries]
|
From: dtoney on 8 Feb 2010 11:21 When capturing data from another database owned by another group, I need all of the data for 120 days from tableA and all of the data that matches by keyID from tableB. However, when I try to pull in the data from a single make Table query, I only get data from TableA that has data in TableB. Is this because I do not have the proper join?
From: Jerry Whittle on 8 Feb 2010 11:43 Yes. You probably have an inner join which requires data in both tables before it will return a record. In query design view, double click on the join line between the two tables until you see a dialog box. Try the second option which is a left join. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "dtoney" wrote: > When capturing data from another database owned by another group, I need all > of the data for 120 days from tableA and all of the data that matches by > keyID from tableB. However, when I try to pull in the data from a single make > Table query, I only get data from TableA that has data in TableB. Is this > because I do not have the proper join?
From: Marshall Barton on 8 Feb 2010 12:49 dtoney wrote: >When capturing data from another database owned by another group, I need all >of the data for 120 days from tableA and all of the data that matches by >keyID from tableB. However, when I try to pull in the data from a single make >Table query, I only get data from TableA that has data in TableB. Is this >because I do not have the proper join? I think so. In the query designer right click on the join line and select the option for all records from tableA and any matching record form tableB -- Marsh MVP [MS Access]
|
Pages: 1 Prev: Querying using SQL statement Next: How can I avoid a cartesian result? |