CONNECT BY--- URGENT

Hi all,

I have written a query joing two tables. and want to use CONNECT BY on that result set of above join.

Can I do that? how?

one example will be verymuch appreciated.


Thanks and Regards