Like clause queries

I have two queries

select T1_Field1 from T1 where T1_Field2 like "deptname"

select * from T2 where T2_Field2 like T1_Field1

Is there anyway to combine these two queries to one? Received on Fri Jan 17 2003 - 11:55:45 CST