Unable to retrieve columns from joined table (PostgreSQL)
Nevermind, I forgot in a join the joined table is in its own attribute.  Closing.

I have two PgSQL tables (servers and api) where api.servers_id = servers.id.  Here are my models:

``` python
class Servers(BaseModel):
    id = BigIntegerField(primary_key=True)
    user = ForeignKeyField(Users, cascade=True)
    ipv4 = CharField(max_length=17)
    ipv6 = CharField(max_length=45)
    hostname = CharField(max_length=256)

class Api(BaseModel):
    id = BigIntegerField(primary_key=True)
    private = CharField(max_length=212)
    public = CharField(max_length=31)
    server = ForeignKeyField(Servers, cascade=True)

servers = Servers
api = Api
```

What I'm wanting to do is get API information based on the server id, so I set up my query like this:

``` python
s = servers
a = api

server_info = s.select(
s.id.alias("sid"),s.ipv6.alias("ipv6"),s.hostname.alias("hostname"),s.ipv4.alias("ipv4"),
a.id.alias("aid"),a.private.alias("private"),a.public.alias("public")
).join(a, self.db.JOIN_FULL).where(s.user==self.uid)
```

The problem is server_info records only have the items of the server itself, not of the api fields as well.  This generates this query:

```
SELECT t1."id" AS sid, t1."ipv6" AS ipv6, t1."hostname" AS hostname, t1."ipv4" AS ipv4, t2."id" AS aid, t2."private" AS private, t2."public" AS public FROM "servers" AS t1 FULL JOIN "api" AS t2 ON (t1."id" = t2."server_id") WHERE (t1."user_id" = 1)
```

Which when ran in PgAdmin gives me the results I want, but not here.  None of the a.\* fields are in the results, just the s.*.
