S-control - Parent child relationship

Hi

I have Account object which has many Products.

Products has three Record Types: Prod1, Prod2 and Prod3.

I'm trying to build a s-control and I want to get the data from one of the Record Types.

I know the Account ID but how can I get the details from record type?

Do I need to have a query statement for this? If so, can you provide me the example or syntax?

Thanks