Greg- Does either table have a Primary Key? Field Y?
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Greg Saucier > Sent: Tuesday, May 03, 2005 11:50 AM > To: [email protected] > Subject: [ms_access] Re: Merge Tables & Data? > > > Hi John, > > Thanks so much for the help. > > Yes the two tables have duplicate data, but not in every field. > There are field differences in the two tables and I am trying to > merge them together. > > In Table A for example I have field X & Y but not Z. > I guess we are wanting to reconcile the records in each table > and merge them into one, thus eliminating the dups and ALSO > bringing the field data over that is not there now. > > If you could imagine a way to bring in an entire FIELD from > one table into another that is what we are trying to achieve. > > Hope that helps. > > Greg > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Greg- > > > > Please explain what you mean by "there are duplicates." Do you > want to > > eliminate the duplicates? Also are there rows in Table A or Table > B that do > > not have a matching Y value in the other table? > > > > Answer these questions, and I can write the appropriate SQL for you > to get > > the job done. > > > > John Viescas, author > > "Building Microsoft Access Applications" > > "Microsoft Office Access 2003 Inside Out" > > "Running Microsoft Access 2000" > > "SQL Queries for Mere Mortals" > > http://www.viescas.com/ > > > > > -----Original Message----- > > > From: [email protected] > > > [mailto:[EMAIL PROTECTED] On Behalf Of Greg Saucier > > > Sent: Tuesday, May 03, 2005 9:04 AM > > > To: [email protected] > > > Subject: [ms_access] Merge Tables & Data? > > > > > > > > > > > > Hi, > > > > > > Can someone help me figure out if its possible to > > > merge two tables together into one while maintaining > > > existing data? > > > > > > For example, Table A has fields X & Y and Table B > > > has fields Y & Z. I want to make a new table (or query) with > > > X, Y & Z and have all the records match (there are > > > duplicates) when I am done. > > > > > > Thanks > > > Greg > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
