Home Forums SQL Server 2014 Development - SQL Server 2014 Odd Join Scenario RE: Odd Join Scenario
deepika0928
SSC Rookie
Points: 39
More actions
March 13, 2018 at 2:53 am
#1982866
Use this.
select coalesce(a.id,b.id,c.id)id,isnull(max(name),'')name,isnull(max(address),'')address,isnull(max(descri),'')descr from tablea a full join tableb b on a.id=b.idfull join tablec con a.id=c.idgroup by coalesce(a.id,b.id,c.id)