SQL query problem

Using my query below, is there a way where the servicearea and location is the same it is only shown once?

SELECT     *
FROM        medicaldevices, location, servicearea
WHERE
medicaldevices.devicelocation=location.locationid
and
medicaldevices.deviceservice=servicearea.serviceareaid

Thanks guys