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 <*> 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/
