mysql error

[eluser]Todlerone[/eluser]
Hello all and TY in advance. I'm trying to do a multiple pull put I'm getting an "Column 'jcc_demo_NumID' in where clause is ambiguous" error

Code:

function get_treatments_where($jccID){
        $this->db->select('    jcc_demographics.jcc_demo_NumID,
                    jcc_demographics.jcc_demo_NameF,
                    jcc_demographics.jcc_demo_NameL,
                     jcc_demographics.jcc_demo_JCCid,
                     jcc_demographics.jcc_demo_Attending,
                     jcc_treatments.jcc_treat_id,
                    jcc_treatments.jcc_treat_num,
                     jcc_treatments.jcc_treat_unit,
                    jcc_treatments.jcc_treat_intercranial,
                    jcc_treatments.jcc_treat_diagnosis,
                    jcc_treatments.jcc_treat_region,
                     jcc_treatments.jcc_treat_location,
                    jcc_treatments.jcc_treat_loc_sagittal,
                    jcc_treatments.jcc_treat_loc_axial,
                    jcc_treatments.jcc_treat_loc_coronal,
                     jcc_treatments.jcc_treat_dose,
                     jcc_treatments.jcc_treat_fractions,
                    jcc_treatments.jcc_treat_RTT,
                    jcc_treatments.jcc_treat_MRI,
                     jcc_treatments.jcc_treat_CT,
                     jcc_treatments.jcc_treat_RFV,
                     jcc_treatments.jcc_treat_VD,
                    jcc_treatments.jcc_treat_PD,
                     jcc_treatments.jcc_treat_DELI,
                     jcc_treatments.jcc_treat_AUTH,
                     jcc_treatments.jcc_treat_START,
                    jcc_plans.jcc_plans_id,
                    jcc_plans.jcc_plans_tracking,
                    jcc_plans.jcc_plans_method,
                    jcc_plans.jcc_plans_rx2,
                    jcc_plans.jcc_plans_beams,
                    jcc_plans.jcc_plans_nodes,
                    jcc_plans.jcc_plans_hrs');
        $this->db->where('jcc_demo_NumID', $jccID);
        $this->db->from('jcc_demographics');
        
        $this->db->join('jcc_treatments','jcc_demographics.jcc_demo_NumID = jcc_treatments.jcc_demo_NumID');
        $this->db->join('jcc_plans','jcc_demographics.jcc_demo_NumID = jcc_plans.jcc_demo_NumID');

        $query=$this->db->get();
        return $query->result_array();
}

Any help would be appreciated.

Cheers

[eluser]sharpe[/eluser]
Should be
$this->db->where('jcc_demographics.jcc_demo_NumID', $jccID);

[eluser]Todlerone[/eluser]
[quote author="sharpe" date="1295906325"]Should be
$this->db->where('jcc_demographics.jcc_demo_NumID', $jccID);[/quote]

TY sharpe that was the ticket....works great now.

CHEERS