Well as a derived table you can do this

(SELECT * FROM table1 with inner join ... ) AS c1

for instance

Select t1, (Select t2 from table1 t where t.t1=t1)...

This is great thanks for the reply. Yes I am able to add the PK and I did set the timeout to 0. Will check how it will work with...