Looks like you have missed the joining columns for the first two tables (
ON
clause)
Add proper columns to the join so something like the following:
select distinct
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,
c.speci,
c.amenities,
s.projectname
from plisting p
join indi s on p.projectid=s.projectid
JOIN Sheet1$ c on s.projectid = c.projectid
WHERE s.projectid='PL2023002'
order by p.projectname,
s.projectname
Also in order for the
DISTINCT
to work, add
s.ProjectName
to the select list (added as the last column)