Hi All,

If I have the following table 'Customers'
Id Ref First Last
-- --- ----- ----
10 10 John Unknown
25 10 Jane Doe

I am having problem combine the two records together using the select statement. If I select Id = 25 and also want to retrieve all the info where Ref=10. The result should like >> 25 10 Jane Doe John Unknown

Is this possible with one select statement. TIA