Remove duplicate from certain columns with sql query

Question

The current query:

$query = sprintf("
SELECT compdetails.compname, compdetails.message, specdetails.expirydate, 
specdetails.specday, specdetails.specname, specdetails.specorig, specdetails.specspec, 
specdetails.startdate, complocations.address, complocations.lat, complocations.lng 

FROM compdetails, complocations, specdetails 
WHERE compdetails.compid='%s' 
        
AND specdetails.compid='%s' 
AND complocations.compid='%s'",
        

So:

Compdetails table:
compname
message

Specdetails table:
expirydate
specday
specname
specorig
specspec
startdate

complocations table:
address
lat
lng

What I'm having issues with:

Removing the dupes from this view. See image

I only need the following listed once:

1. compname message
   2. expirydate, specday, specname, specorig, specspec, stardate once each for each address
   
2. lat,lng per address
   
   

Answer 1

SELECT compdetails.compname, compdetails.message, specdetails.expirydate, 
    specdetails.specday, specdetails.specname, specdetails.specorig, specdetails.specspec, 
    specdetails.startdate, complocations.address, complocations.lat, complocations.lng 

FROM compdetails, complocations, specdetails 
WHERE compdetails.compid='%s' 

AND specdetails.compid='%s' 
AND complocations.compid='%s'
GROUP BY compdetails.compname"

If you are instead wanting to show all rows but omit certain values on some rows you will have to use logic in your view.