Post category

I am writing an extension for WordPress and need to know how to determine the post category. In brief, I need to associate all posts with their corrosponding categories using some SQL.

I thought post_parent under posts table might be of help but it confuses me more. A SQL condition or field names would be helpful.