select o.name, i.name
from sysobjects o, sysindexes i
where o.id = i.id
select o.name, i.name
from sysobjects o inner join sysindexes i
on o.id = i.id
select o.name, i.name
from sysobjects o, sysindexes i
where o.id = i.id and
indid = 1
select o.name, i.name
from sysobjects o inner join sysindexes i on o.id = i.id
where indid = 1
update t1
set t1.col = ............from t1 inner join t2 on t1.col = t2.col
delete t1
from t1 inner join t2 on t1.col = t2.col