• ssc_san (4/5/2013)


    Thanks for the reply Lynn Pettis.

    There are two records with a value of '1' for column c1, t1 value for those records is null where as t2 has values as 'X' and 'O'. I want to display null's for those two records for t2 with out hardcoding or using case with in case.

    Thanks again!

    So, to paraphrase, the results for t2 should mirror the results of t1, correct?