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
Comments
Post a Comment