how to write SQL hints for this query?

[kknight2046]

The query is like:

select * from foo, t
where foo.name in
(select name from bar
where id in (
select id from car
where date < sysdate
)
)
and foo.a = t.b;

I want the innermostsubquery 'select id from car ...' to be executed first, and the subquery 'select name from bar ...' to be execute second, and the outermost query 'select * from foo,t ...' to be executed the last. How can I write the Oracle sql hints to force the order?

Thanks.

 

[jimirvine]

1. You can't
2. The way you have written it, oracle will execute the code in this manner anyway.