How can I implement this a recursive join in a group between two tables?

How can I implement this a recursive join in a group between two tables?

References

Reference NO 1

http://stackoverflow.com/questions/15202890/how-can-i-implement-this-a-recursive-join-in-a-group-between-two-tables

Reference NO 2

http://docs.oracle.com/cd/E16655_01/server.121/e15858/tgsql_join.htm

Reference NO 3

http://www.dbspecialists.com/files/presentations/semijoins.html

Reference NO 4

http://www.postgresql.org/docs/9.1/static/queries-with.html

Reference NO 5

http://www.firebirdsql.org/refdocs/langrefupd21-select.html

Reference NO 6

http://www2.sas.com/proceedings/sugi22/BEGTUTOR/PAPER67.PDF

Reference NO 7

http://netmatze.wordpress.com/2012/03/22/implementing-a-recursive-common-table-expression-cte/

Reference NO 8

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/rzajq/perf24.htm