How to do JOINS using the ORM

[cfcoder]

Having trouble with a simple join to a lookup table called "lookup_values" in the db I'm using.
I also have a "users" table that has an "area_id" column that is a FK to the "id" (PK) of the lookup_values table.

In the models/User.cfc, in the config() function I added:

hasOne(name="userArea", modelName="lookup_value", foreignKey="id", joinKey="area_id");

In a controller file I place this code to call that and dump the output.

users = model("user").userArea();
writeDump(users);
abort;

I keep getting the error:
Element ID is undefined in a Java object of type class coldfusion.runtime.TemplateProxy.

What am I doing wrong?

A bonus question:
How do you join a table to more than one other table...
FROM tableA a
JOIN tableB b ON b.a_id = a.id
JOIN tableC c ON c.a_id = a.id

[cfcoder]

Guess I gave up too soon. Reviewing the docs for associations to multiple tables, I found that when I do it like this in the model file's config():

hasOne(name="userArea", modelName="lookup_value", foreignKey="id", joinKey="area_id");

and in the controller file action:

users = model("user").findAll(include="userArea");

it works.

I also found how to join multiple tables there in the docs (doh!), just csv list of association names in that include list value...
include="userArea,userRole"