Left Join

noko

Field::inst( 'book_list.school_list_code' )
->options( 'school_link', 'school_list_code','school_list_code' ),
Field::inst( 'school_link.school_list_code' ),

Field::inst( 'book_list.school_code' )
->options( 'school_link', 'school_code','school_code' ),
Field::inst( 'school_link.school_code' ),

Field::inst( 'book_list.school_name' )
->options( 'school_link', 'school_name','school_name' ),
Field::inst( 'school_link.school_name' ),

)

->leftJoin( 'school_link', 'school_link.school_list_code', '=', 'book_list.school_list_code')

I have three select options coming from the same table. The first option 'school_list_code' manages to update, the other two doesnt, it only allows you to add. Am I doing something wrong in my left join ?