ОШИБКА 1241 (21000): операнд должен содержать 1 столбец (столбцы)
my SQL Query:
select * from tbl_vehicle
join tbl_driver on tbl_vehicle.pk_vehicle_id = tbl_driver.fk_vehicle_id
join tbl_location on tbl_driver.pk_driver_id = tbl_location.fk_driver_id
join tbl_company on tbl_driver.fk_company_id= tbl_company.pk_company_id
where driver_mob
NOT IN
(
select * from tbl_vehicle
join tbl_driver on tbl_vehicle.pk_vehicle_id = tbl_driver.fk_vehicle_id
join tbl_location on tbl_driver.pk_driver_id = tbl_location.fk_driver_id
join tbl_company on tbl_driver.fk_company_id= tbl_company.pk_company_id
where
(tbl_location.latd BETWEEN '9.835443' AND '10.226975' )
AND
(tbl_location.longd BETWEEN '76.201205' AND '76.77894')
and
tbl_company.Company_name='Kerala'
and
tbl_driver.active_flag=1
);
it is showing error 1241, how can i modify this to avoid error? любой кусок кода ценится и спасибо заранее.