[sridhars]

I have a table "data_taxonomy" with following data

tid data_table_name id
3 feeds_data_syndication 234
40 feeds_data_syndication 97
43 feeds_data_syndication 101
77 feeds_data_syndication 97
79 feeds_data_syndication 1
80 feeds_data_syndication 97
85 feeds_data_syndication 97
85 feeds_data_syndication 99
85 feeds_data_syndication 221
783 feeds_data_syndication 97

I got tid values from other query that are.
40,77,80,85,783

My requirement is
For that above tid values corresponding id value is common in the "data_taxonomy" table . Then only i want that id value.The output should be like this
output:
id
97


Tanks.

[nafirici]

select id
from data_taxonomy
where tid IN (40,77,80,85,783)