Expanding Hierarchies

[Sajid]

Hello

I am developing a multi level marketing website. I have a
table "members" with fields memberid, name, address,
parentId. This table has a recursive relationship.

Is it possible to query either all left children (grand
children ...) or right children or both of a specific
parent with an sql statement as we can do in Oracle with
the help of connect by clause. Any ideas.

If there is any related article, it will be very helpful.

Regards

Sajid