I think that would have to be like

SELECT A, B, C.S1 from Table1, (SELECT S1 FROM Table2) as C WHERE C.S1>10

but it would need something more to define the relationship between table1 and table2.