pls tell me why my query generate the repeating data of projectname and projectid of boh table my query is
select p.projectid,p.projectname,p.location,p.bedrooms,p.city,p.overview,p.price,s.builduparea,s.bedrooms,s.bathrooms,s.propertyonfloor,s.price,s.units
from plisting p join
Sheet1$ s on p.projectid=s.projectid WHERE s.projectid='PL1839200'
order by p.projectname,s.projectname
pls solve this problem