连接两个包含许多字段的表，但会产生许多重复的结果。 [英] joining two tables with many fields but that gives many duplicate result .

问题描述

我正在使用此查询加入表格请给我正确的解决方案

 选择 
 b.FValue 作为标题，
 k.FValue  as 副标题，
 c.FValue  as  isbn，
 d.FValue  as  issn，
 E.FValue  as 作者，
 f.FValue  as  roleofauthor ，
 g.FValue  as 编辑器，
 h.FValue  as  publisher，
 i.FValue  as  publisherPlace，
 j.FValue  as  pyhsicaldescription，
 m.FValue  as  Subject，
 n.FValue  as 注意，
 l .p852  as  Acc essionNo，
 l.DateofAcq  as  AccessionDate，
 l.a852  as  location， 
 l.Budget  as  Budget，
 l.k852  as  ClassNo，
 l.m852  as  bookNo，
 l.Price  as 价格，
 l.t852  as  CopyNo，
 l.Supplier  as 供应商，
 l。 b852  as  collectionttype，
 l.Material 作为材料，
 l.status 
 来自 Biblidetails b 
  left   join  Biblidetails c  on  b.RecID = c.RecID 和 c.Tag =  020  和 c.SbFld = '  a' 
  left   join  Biblidetails d  on  b.RecID = d。 RecID 和 d.tag =  022  和 d.SbFld = '  a' 
  left   join  Biblidetails e  on  b.RecID = e.RecID 和 e.Tag =  100  和 e.SbFld =   a' 
  left   join  Biblidetails f  on  b.RecID = f.RecID  a nd  f.Tag =  100  和 f.SbFld = '  e' 
  left   join  Biblidetails g  on  b。退出= g.RecID 和 g.Tag =  250  和 g.SbFld = '  a' 
  left   join  Biblidetails h  on  b.RecID = h.RecID 和 h.Tag =  260  和 h.SbFld = '  b' 
  left   join  Biblidetails i >  b.RecID = i.RecID 和 i.Tag =  260  和 i.SbFld = '  a' 
  left   join  Biblidetails j  on  b.RecID = j.RecID 和 j.Tag =  300  和 j.SbFld = '  a' 
  left   join  Biblidetails k  on  b.RecID = k .RecID 和 k.Tag =  245  和 k.SbFld = '  b' 
 左  join  Biblidetails m  on  b.RecID = m.RecID 和 m.Tag 喜欢 '  6％' 和 m.SbFld = '  a' 
  left   join  Biblidetails n  on  b.RecID = n.RecID 和 n.tag 喜欢 '  5％' 和 n.SbFld = < span class =code-string>'  a' 
  left  < span class =code-keyword> join  location l  on  b.RecID = l.RecID  w这里 b.Tag =  245  和 b.SbFld = '  a' 

解决方案

尝试区别：

 选择  distinct  
 b.FValue  as  title，
 k.FValue  as 副标题，
 c.FValue  as  isbn，
   -    ...  

I am using this query for the joining the table pls give me proper solution

select 
   b.FValue as title, 
   k.FValue as subtitle, 
   c.FValue as isbn, 
   d.FValue as issn,
   E.FValue as Author, 
   f.FValue as roleofauthor,  
   g.FValue as editor, 
   h.FValue as publisher, 
   i.FValue as publisherPlace, 
   j.FValue as pyhsicaldescription,  
   m.FValue as Subject , 
   n.FValue as Note , 
   l.p852 as AccessionNo, 
   l.DateofAcq as AccessionDate,
   l.a852 as location,
   l.Budget as Budget, 
   l.k852 as ClassNo, 
   l.m852 as bookNo ,
   l.Price as Price,
   l.t852 as CopyNo,
   l.Supplier  as supplier ,
   l.b852 as collectionttype,
   l.Material As materials,
   l.status 
from         Biblidetails b  
   left join Biblidetails c on  b.RecID = c.RecID and c.Tag = 020 and c.SbFld = 'a' 
   left join Biblidetails d on b.RecID = d.RecID and d.tag = 022 and d.SbFld = 'a' 
   left join Biblidetails e on  b.RecID = e.RecID and e.Tag = 100 and e.SbFld = 'a' 
   left join Biblidetails f on  b.RecID = f.RecID and f.Tag = 100 and f.SbFld = 'e' 
   left join Biblidetails g on  b.RecID = g.RecID and g.Tag = 250 and g.SbFld = 'a'
   left join Biblidetails h on  b.RecID = h.RecID and h.Tag = 260 and h.SbFld = 'b'
   left join Biblidetails i on  b.RecID = i.RecID and i.Tag = 260 and i.SbFld = 'a'
   left join Biblidetails j on  b.RecID = j.RecID and j.Tag = 300 and j.SbFld = 'a' 
   left join Biblidetails k on  b.RecID = k.RecID and k.Tag = 245 and k.SbFld = 'b' 
   left join Biblidetails m on  b.RecID = m.RecID and m.Tag like '6%' and m.SbFld = 'a'
   left join Biblidetails n on  b.RecID = n.RecID and n.tag like '5%' and n.SbFld = 'a'
   left join location l on b.RecID = l.RecID   where b.Tag = 245 and b.SbFld = 'a'

解决方案

Try Distinct:

select distinct
   b.FValue as title, 
   k.FValue as subtitle, 
   c.FValue as isbn, 
   --...

这篇关于连接两个包含许多字段的表，但会产生许多重复的结果。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！