no118.co.uk
18th June 2010, 07:13
1) SELECT BPR_shift_doctor.id, BPR_shift_doctor.id_day, BPR_shifts.name , BPR_days.name as d_name FROM BPR_shift_doctor inner join BPR_shifts on BPR_shift_doctor.id_shift=BPR_shifts.id inner join BPR_days on BPR_shift_doctor.id_day=BPR_days.id Where BPR_shift_doctor.id_doctor=12 ORDER BY id_day ASC LIMIT 0, 10
[nativecode=1054 ** Unknown column 'BPR_shift_doctor.id_day' in 'field list']
[nativecode=1054 ** Unknown column 'BPR_shift_doctor.id_day' in 'field list']