The only problem with this is when ColumnRef = 1000 doesn't exists, because variable still being NULL.

Cool. But I'd like to know if using INNER JOIN has less IO cost on DB than using a regular T1.PK1 = T2.FK2 ??

Thanks,