You can use SQL JOIN statements to combine data from three or more tables. In an earlier article, we took a look at using inner joins and outer joins to combine data from two different tables. In many cases, you’ll want to take this a step further and combine data from three or more tables. In Joining Multiple Tables with SQL Inner Join Statements, we look at the SQL statements that allow you to accomplish this goal for an inner join.

Read the full article: Joining Multiple Tables with SQL Inner Join Statements

In a recent forum posting, picako wrote:

"Hello all, I am a very new user to Microsoft Access and I'm not sure if I can do what I want to with it.

I work with a new property investment company and we would like to design a database for all the properties that we look at, to make sure we are not double looking. What I would like to be able to do is have several tables (property description, pricing info, realtors, etc), each record within a table would be related to just one property. There will be a column titled ID# that will be the same on each table. I would then like to be able to pull all the information related to just one property to a query or report. Is this possible and if so how do I do it? Thanks in advance for any help"

Can you help picako? Interested in solutions to the same problem? Visit the About Databases forum and join the discussion.