Home Forums SQL Server 2008 SQL Server Newbies IF statement with the Select RE: IF statement with the Select

  • January 26, 2015 at 8:29 pm

    #1773285

    montserrat.deza (1/26/2015)

    Hello,

    I need to create a SQL statement with the evaluation of two options with the following logic:

    IF TABLEAVALUEA <> TABLEBVALUEA

    {select TABLEAVALUEA,TABLEBVALUEA,TABLEBVALUEC,

    from TABLEA

    join TABLEB on TABLEAVALUEA = TABLEBVALUEA

    [ELSE

    {DONT DO ANYTHING } ]

    what will be the best approach using t-sql commands?

    Thank, you

    I think you're describing something that can't happen. Your join requires that the values be equal and you're wanting to take action when those equal value are not equal.