How to join 2 database tables [was: Records]

Hello to all;
Can I show a list of records from two different tables in my DB?

1 Like

As long as their is a field to join on yes, that’s fundamental to sql.
I suggest you google something like “sql joins” for info

This may help

Lets me explain what I am trying to do. I have two different tables in my DB and there a field that is the same for both. What I want to do is to create a page using wrappler that show in this case all the doctors offices but some of the offices have another office in other city. These others office are in a sencond table in the DB. I want in my page to show boths offices in one list. My first language is not english, so I don’t know if I am explaining correctly.

From what I understand, I believe you need to do this:

I will try that, should works. I post my results. thanks