same ids in a tbl

[hganta]

hai,

I have businessrel_tbl in which a column businessreltype pairid is existing.

In the businessreltype pairid there will be relateionids for auditor(17), client(16), supplier(2) etc.

I want to retrieve data with both auditor and client ids. can any one please provide me the query.

[debasisdas]

Please post your exact table structure for further discussions on the topic.