SQL query problem

[matthisco]

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

[Dan_Bracuk · Accepted solution]

instead of select *, select just the fields you intend to use.

Also, use select distinct