Table Tables

Table Tables
how can i combine the data in three tables in order to have only one table in Microsoft Access?

i am working on a database and i have three tables. I want to combine them so that i can be working with one table.
the three tables have four identical columns (same field name and data) but there are other columns which are unique to each table.
the three tables have different number of rows ( first table has 1019 rows, second table has 1018 rows, and third table had 934 rows).
how can i combine these tables and how do i deal with the uneven number of rows?

I would assign relationships between the tables instead.

Kramer coffee table book on “Regis & Kathie Lee”

eBay Logo  

NEW - Marseilles Accent Table


NEW – Marseilles Accent Table


$124.85


300 ct Las Vegas Poker Chips 14 table grams 14g Laser


300 ct Las Vegas Poker Chips 14 table grams 14g Laser


$29.99


20 Vintage Music Heart  Double Sided Wedding Table Confetti Shabby Chic 3


20 Vintage Music Heart Double Sided Wedding Table Confetti Shabby Chic 3″


$1.56


Grn White Butterfly Handbag Table Holder Folding Hanger


Grn White Butterfly Handbag Table Holder Folding Hanger


$6.85


GOLD 6MM STAR FOILETTI / TABLE CONFETTI! PARTY ITEM!


GOLD 6MM STAR FOILETTI / TABLE CONFETTI! PARTY ITEM!


$2.13


Country Wine Tan Plaid Live Laugh Love Sturbridge Table Runner 13x54


Country Wine Tan Plaid Live Laugh Love Sturbridge Table Runner 13×54


$28.95


Country Tan Ivory Burgundy Green Plaid Thyme Table Cloth 54x54


Country Tan Ivory Burgundy Green Plaid Thyme Table Cloth 54×54


$22.95


Officially Licensed - Bud Light Lime Pub Table - 28


Officially Licensed – Bud Light Lime Pub Table – 28″ Diameter – 42″ Tall


$209.99


Christmas Plaid Dresden Plate Table Mat  Quilt Kit


Christmas Plaid Dresden Plate Table Mat Quilt Kit


$9.95


Petite Antique English Carved Oak Wine End TABLE or Plant Stand Ebonized


Petite Antique English Carved Oak Wine End TABLE or Plant Stand Ebonized


$219.00