Creating a query from multiple tables

[Mordacia]

Hi, this seems like it should be easy to do, but every time I try to run a query off of several tables, it does not work. I want to pull all the data from all the fields of the three tables, but when I try to select * from each table to enter all the fields and then run the query, I get TableName.FieldName for each field, but there is no data in any of the fields. The fieldnames for all the tables are the same, so how can I pull the data from all tables into one set of fields and then populate it with all the data currently in all three tables?

Thanks!

 

[smedvid]

First, you will need to understand that in order to pull data from various tables there needs to be a common field to link between those tables. This is the basis of Relational Databases. Once you have a grasp of that concept, you can develop queries. Review online tutorials that may provide some background and examples. htwh Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/