How to do it in SQL

Say i have a table called 'company' with the following fields: company_id company_name parent_company_id How can I get a listing of all of a Companies Parents without using a FOR loop? Sample DATA: Record 1: company_id = 1 company_name = Company one parent_company_id = 2 Sample DATA: Record 2: company_id = 2 company_name = Company two parent_company_id = 3 Sample DATA: Record 3: company_id = 3 company_name = Company three parent_company_id = NULL I want to execute a select that gives me BOTH of the parents for company _id = 1 -Toby Denbow tdenbow@mathworks.com