I have 2 tables vehicle and worker.
number of workers under a vehicle mau be 10 or 25.
vehicle(veh_id(pimary key),vehicle name, details)
worker(work_id(pimary key),veh_id(foreign key),worker name)
i have to list all records from vehicle table and to count how many workers exists under a vehicle.
if no workers under a vehicle indicate 0.
what i need is that It should be with asingle query.
i have to list all date from vehicle table and to list how many workers under a vehicle(i mean count the workers)???
Last edited by fernandodonster; 08-25-09 at 01:56.