join Tables

[jamesfranklin]

Hi,
I'm having 5 tables with different fields i want join all table's into single table in single query.


Thanksssss

 

[Alansidman]

In order to join the fields they must all have a common field to join on. Do your tables have common fields with each other? If not then you will get a cartesian result.

 

[Galaxiom]

Depends on what you mean by "join". Literally in database-speak the join is as described by Alan. This combines the joined records from multiple tables into one record.

Alternatively you may be looking for a Union query. This takes the separate records from all the tables and puts them in one table with the existing fields. In the case the selected fields in all tables need to be the same kind of data.

 

[jamesfranklin]

Hi,
i'm having 5 different types of tables with different feilds

thank u.........

 

[Galaxiom]

Please describe your tables and give an example of what you want the output to look like.

 

[jamesfranklin]

hi,
I'm having 5 tables. Each table having 5 fields.
Table1
First_Name, Last_Name, Email_id, Phone_no, Address
Table2
First_name, Last_name, State, Country, Zip code
Table3
First_name, Last_name, Full_Name, Email_id, Address
....................
........................
....................Like this

I want to Join all 5 tables into one table using single query. Thankssssssssssss......

 

[Galaxiom]

Create a new query.
Drag in all the tables.
Drag FirstName from Table1 to each of the other FirstName fields.
(This should draw line between the fields.)
Repeat this for LastName.
Drag each field you want from each table into the output down to the query grid.

This query will return records joined on FirstName and LastName showing the values for the fiedls from all tables.

Only records matched with Fistname and LastName that exist in all tables will be included. If you need all the records even if they are only in one table, right click on the lines and select the appropriate join type as is described in the window.

You may have to change the joins to be from one table to the next in sequence to get exactly what you want depending on what that would be.

 

[jamesfranklin]

Thanks for ur reply Galaxiom
ya it may be correct. what my option is here i created back end database user will enter data using front end database and every 1/2 i want check whether they complete or not by this i want to change the field every 1/2 hour right. Because different type users working on this file with different fields.
any other way for this.


thank u.........