For example, I have the following tables :

```
account : ID, Login, Pass, Name

records : ID, Info, SubmitterID

```

And use the following command to select some data :

```
SELECT account.Name
    , records.Info
    FROM account, records
    WHERE account.ID = records.ID

```

Now I would like to display the Name field when `records.SubmitterID = account.ID` does anyone know if thats possible?

Thanks.