Tel : +32 (0)2 352 01 31

Email :

Brussels, Belgium

Erreur SQL !
SELECT V.*, M.ma_ma, M.ma_lk, S.se_se, S.se_lk, O.mo_mo, T.ty_ty, C.*, TX.txt_fr, D.DEP_ID, D.DEP_LK_fr, D.DEP_fr FROM veh_car V LEFT JOIN veh_txt TX ON (V.car_ess = TX.txt_id) LEFT JOIN veh_m_ma M ON (V.car_ma=M.ma_id) LEFT JOIN veh_m_se S ON (V.car_se=S.se_id) LEFT JOIN veh_m_mo O ON (V.car_mo=O.mo_id) LEFT JOIN veh_m_ty T ON (V.car_ty=T.ty_id) LEFT JOIN veh_car_cat C ON (V.car_cat = C.CAT_ID) LEFT JOIN veh_car_dep D ON (V.car_dep = D.DEP_ID) WHERE car_sta = '1' AND car_typ = '0' AND car_dep != '9' AND ma_lk = 'kamaz' AND se_lk = '5321515' AND car_etat = '11' GROUP BY car_id ORDER BY C.car_vol ASC, M.ma_ma ASC, S.se_se ASC, O.mo_mo ASC, T.ty_ty ASC, car_tpx + 0
Unknown column 'C.car_vol' in 'order clause'