• Have you tried this?

    Select top 100 * from (

    select * from table1

    left outer join table2 on table1.id = table2.id

    left outer join table3 on table1.id = table3.id

    )

    Also be notified that rownum < 100 returns 99 rows only. Use rownum <= 100.