مقارنة قيم من جدولين

if(
(select col1 from Table1 where condition)
=
(select col2 from Table2 where condtion)
)
print('Equals')
else
print('Not equals')

look to this code

select 
	Table1.cal1,
	Table2.col2, 
	case when Table1.cal1=Table2.col2 then 'Equals' else 'Not equals' end as sval
from 
	Table1 inner join Table2 
	on 
	Table1.CalID=Table2.CalID