SQL query problem

using query below, there way servicearea , location same shown once?

 

select     *
from        medicaldevices, location, servicearea
where
medicaldevices.devicelocation=location.locationid
and
medicaldevices.deviceservice=servicearea.serviceareaid

 

thanks guys

instead of select *, select fields intend use.

 

also, use select distinct

More discussions in Database Access

adobe