PC Review


Reply
Thread Tools Rate Thread

combine tables

 
 
Boss
Guest
Posts: n/a
 
      18th Aug 2008
Hi,

I wish to combine three tables into one. Please help

Thanks!
Boss
 
Reply With Quote
 
 
 
 
Alex Dybenko
Guest
Posts: n/a
 
      18th Aug 2008
Hi,
you can either use append query and put data into 1 table, or use UNION
query for get data from all 3 tables like:
select field1 from table1
union
select field1 from table2
union
select field1 from table3

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

"Boss" <(E-Mail Removed)> wrote in message
news:C574DDAA-06C5-4E9C-9B6B-(E-Mail Removed)...
> Hi,
>
> I wish to combine three tables into one. Please help
>
> Thanks!
> Boss


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I combine 2 tables? sabow71 Microsoft Access Queries 3 1st Feb 2010 05:31 PM
combine tables CandiC Microsoft Access Getting Started 1 27th Aug 2009 07:06 PM
Combine tables =?Utf-8?B?Um9zZQ==?= Microsoft Access 3 17th Aug 2007 03:14 PM
How to combine 27 tables? Ted Microsoft Access 5 9th Sep 2005 07:57 PM
Combine tables JoeCL Microsoft Access Database Table Design 1 24th Dec 2003 09:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:30 PM.