Table for Tags and categories

Hi Guys,

I wanted to use sql query to get the tags assined to a news item. I have the  ur for the news item details page. Any one have idea about this.

How can I query this out?

Thanks,
Paul