Does anyone know why the following is resulting in a Column 'id' in field list is ambiguous error?
$app_subj_current = \DB::table('tbl_subject')
->join('tbl_application', 'tbl_subject.id', '=', 'tbl_application.app_subj_id')
->where('tbl_application.id', $application)
->lists('tbl_subject.subj_type', 'tbl_subject.id');
I've specified the table for which ID I'm referring to so I cannot understand why I'm getting this error.