ОШИБКА 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? любой кусок кода ценится и спасибо заранее.

0 ответов

Другие вопросы по тегам