S
Sonja
Hi
I will try to explain what I am trying to do, here goes.
I ave orders, bookings,locations,vehicles and drivers tables, I need to make
a query of drivers and vehicles for a specified date, then using the SQL code
in that query, create another query to search the vehicles and drivers that
do not hav orders on the specified date,
I can get it working using a query each for the vehicles and drivers, but
when I try to do one query to show vehicles and drivers combined, an error
message comes up saying "you have written a subquery that can return more
than one field without using the EXISTS reserved word in the main query's
FROM clause. Revise the SELECT statement of the subquery to request only one
field"
Does anyone have any ideas of how I can overcome this. ultimately I want to
create a form and report from the query
thank you
I will try to explain what I am trying to do, here goes.
I ave orders, bookings,locations,vehicles and drivers tables, I need to make
a query of drivers and vehicles for a specified date, then using the SQL code
in that query, create another query to search the vehicles and drivers that
do not hav orders on the specified date,
I can get it working using a query each for the vehicles and drivers, but
when I try to do one query to show vehicles and drivers combined, an error
message comes up saying "you have written a subquery that can return more
than one field without using the EXISTS reserved word in the main query's
FROM clause. Revise the SELECT statement of the subquery to request only one
field"
Does anyone have any ideas of how I can overcome this. ultimately I want to
create a form and report from the query
thank you