SELECT Diw_Tb_Court.Fd_CourtCode,Diw_Tb_Court.Fd_CourtName + ' '+ Diw_Tb_CourtType.Fd_CourtType AS Court from table1 one inner join table2 to etc.....
select isnull(Diw_Tb_CourtType.Fd_CourtType, Diw_Tb_Court.Fd_CourtName) as Court from table1
select coalesce(Diw_Tb_CourtType.Fd_CourtType, Diw_Tb_Court.Fd_CourtName) as Court from table1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)