在两个表的连接中重复数据 [英] Repeating data in join of two table

问题描述

请告诉我为什么我的查询生成项目名称的重复数据和boh表的projectid我的查询是

 选择 p.projectid，p.projectname，p.location，p.bedrooms，p.city，p.overview，p.price，s.builduparea，s.bedrooms，s。浴室，s.propertyonfloor，s.price，s.units 
 来自 plisting p  join  
 Sheet1 $ s  on  p.projectid = s.projectid  WHERE  s.projectid = '  PL1839200' 
  order   by  p.projectname，s.projectname 

请解决此问题

解决方案

s p.projectid = s.projectid WHERE s.projec tid = ' PL1839200'
order by p.projectname，s.projectname

请解决此问题

 选择   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 
 来自 plisting p 
   inner   join   Sheet1 

s on p.projectid = s.projectid
WHERE s。 projectid = ' PL1839200'
order by p.projectname，s.projectname

Happy Coding！

：）

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

解决方案

s on p.projectid=s.projectid WHERE s.projectid='PL1839200' order by p.projectname,s.projectname

pls solve this problem

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
from plisting p 
inner join Sheet1

s on p.projectid=s.projectid WHERE s.projectid='PL1839200' order by p.projectname,s.projectname

Happy Coding!
:)

这篇关于在两个表的连接中重复数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！