Select With Cascading Variables

Is there a way to write an insert where the values you're inserting depend on another value in the row. Here is an example of pseudo-code that hopefully demonstrates what I'm tryihg to do:


declare @k1 varchar(100)
declare @k2 varchar(100)
declare @k3 varchar(100)


insert into tbl2
select

field1,
field2,
field3,
@k1=(select sm from tbl3 where mm=field1),
@k2=(select sm from tbl3 where mm=@k1),
@k3=(select sm from tbl3 where mm=@k2)
from

tbl1
where

blah= blahblah and
bldfddf = dfaljk



My main focus is using the variables @k1 - @k2 in the where part of subsequent subqueries in the select statement. I haven't been able to get this to work, but I thought maybe something like it would work. I'd like to do this in one statement rather than using a cursor or loop. I'm also trying to avoid functions. Any help would be appreciated.