SQL Statement Insert Into
in [Queries]
|
From: Troy on 12 Jan 2010 23:00 I need to append data from one table1 to table2 using the field in table3 as the criteria. This field in question is 'account number'. How can I write a sql statement to accomplish this?
From: Gina Whipp on 12 Jan 2010 23:25 Troy, What binds the tables? In other words, how are they related to each other? Unless the account number is the same for every entity in Table2? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Troy" <Troy(a)discussions.microsoft.com> wrote in message news:457D4F0C-2C8E-4805-96F2-DAE39E4476F5(a)microsoft.com... >I need to append data from one table1 to table2 using the field in table3 >as > the criteria. This field in question is 'account number'. How can I > write a > sql statement to accomplish this? > >
From: John W. Vinson on 12 Jan 2010 23:30 On Tue, 12 Jan 2010 20:00:01 -0800, Troy <Troy(a)discussions.microsoft.com> wrote: >I need to append data from one table1 to table2 using the field in table3 as >the criteria. This field in question is 'account number'. How can I write a >sql statement to accomplish this? > I would GUESS that you would join Table1 to Table3 on [account number], and base your append query on this - but your post is sufficiently vague that this is just speculation. What's in the tables? How are they related? Do you want to append all records in table1 which have a match in table3 or only a subset? -- John W. Vinson [MVP]
From: Troy on 13 Jan 2010 12:49 Table2 was a table made from Table1 from a make a table query so the fields are the same. The criteria I would like to use is a list of account numbers from Table3. The field has the same name 'account number' as the other 2 tables. I hope I was clearer today. I made my first post at night after a long day! "John W. Vinson" wrote: > On Tue, 12 Jan 2010 20:00:01 -0800, Troy <Troy(a)discussions.microsoft.com> > wrote: > > >I need to append data from one table1 to table2 using the field in table3 as > >the criteria. This field in question is 'account number'. How can I write a > >sql statement to accomplish this? > > > > I would GUESS that you would join Table1 to Table3 on [account number], and > base your append query on this - but your post is sufficiently vague that this > is just speculation. What's in the tables? How are they related? Do you want > to append all records in table1 which have a match in table3 or only a subset? > -- > > John W. Vinson [MVP] > . >
From: John W. Vinson on 13 Jan 2010 18:55
On Wed, 13 Jan 2010 09:49:01 -0800, Troy <Troy(a)discussions.microsoft.com> wrote: >Table2 was a table made from Table1 from a make a table query so the fields >are the same. The criteria I would like to use is a list of account numbers >from Table3. The field has the same name 'account number' as the other 2 >tables. > >I hope I was clearer today. I made my first post at night after a long day! Well, I'm still confused. It sounds like Table2 contains the same records as Table1 (which is redundant and bad design), and you want to add records from... Table1. Wouldn't they already be there!? That said, you can create a Query joining Table1 to Table3 by Account Number. This query will contain all records in Table1 which have a matching account number in Table3. You can then change the query into an Append query, specifying Table2 as the target. The entire process smells very fishy to me though!!! -- John W. Vinson [MVP] |