charan kumar

charan kumar

  • 1.7k
  • 45
  • 5.5k

Joining Tables with no matching columns

Feb 10 2022 12:27 PM

Hi All Good Evening,

I am trying to display check box values when checked in other page.I found that the values are reflecting from databse . So I tried like this.

ELSE IF @fkTerm = (SELECT TOP 1 nID FROM LookUp.Terms WHERE cTerm = 'Additional Property Not Covered')
         BEGIN 
             SET @cTempTerm = '{Building} Term: {Term}'
             SELECT @cTermItem = REPLACE(
                                          REPLACE(
                                                   @cTempTerm,
                                                   '{Building}',cast(c.nLocNum as varchar(3)) + '-' + CAST(c.nBuilding as varchar(3))
                                                   ),
                                          '{Term}',
                                          CASE WHEN nc.cOption = 'Aircraft and aircraft products' THEN
                                             'Aircraft and aircraft products'
                                          ELSE nc.cOption END
                                          )
                                          + @cNewLine
                                          + @cTermItem
           
           FROM  [Save].PropCoverage c ,[LookUp].[AdditionalPropertyNotCovered] nc
           WHERE  nCoverage = 17          
            SET @cTermFilled = 'Additional Property Not Covered:' + @cNewLine + @cTermItem
        END
 

 

Here I want to display multiple checkboxes when checked . including that I need to show other details from other table. But these two tables have no matching columns that's why I tried like abouve but not displaying the values.

Please help me.Thanks!


Answers (1)