join Error Number: 1054

[eluser]winter[/eluser]
Maybe I'm doing something wrong. However, I've been able to run these kind of queries before(non-CI AR)

Doing this:

Code:

$this->db->select('resreq.*, resreq.id AS resreq_id, area.id AS area_id, area.name AS area_name');
$this->db->from('resreq');
$this->db->join('areas', 'areas.id = resreq.unit');
$data['query'] = $this->db->get('resreq');

Results in this:

Code:

An Error Was Encountered

Error Number: 1054

Unknown column 'area.id' in 'field list'

SELECT resreq.*, resreq.id AS resreq_id, area.id AS area_id, area.name AS area_name FROM (`resreq`) JOIN `areas` ON areas.id = resreq.unit

This does work:

Code:

$this->db->select('resreq.*, resreq.id AS resreq_id');
$this->db->from('resreq');
$this->db->join('areas', 'areas.id = resreq.unit');
$data['query'] = $this->db->get('resreq');

However, I have no way of referencing the area.name field in my view:

Code:

<td>&lt;?=$row->area_name?&gt;</td>

Is there a work around for this? Or is this a bug? It seems like a pretty common thing to want to do.

Thanks...

[eluser]Derek Allard[/eluser]
area (singular) vs areaS (plural)?

[eluser]winter[/eluser]
[quote author="Derek Allard" date="1209589693"]area (singular) vs areaS (plural)?[/quote]
You're a genius. I must remind myself to leave work on time and let sleep sort it out. Thanks and sorry for the waste of time.