techmarimuthu (7/2/2013)but i wanna extra add distinct for C_recid
Do you mean there are more records in the resultset with the same value for "C_redid"? And you want just 5 unique records in your resultset that displays each value in the IN() clause?
Can you post some DDL (table definition) statements and sample data (INSERT statements).
To get an unique resultset you can add a GROUP BY or use SELECT DISTINCT to the query. But it depends on the other columns in your SELECT statement, if this will give you the desired result. We need to know how to handle the data in the other columns.
Like if the data in your tables is like this sample below...
[font="Courier New"]C_redid column_value
50194 'basic'
50194 'advanced'
50194 'expert'[/font]
...and you want only one row in your resultset: wich value of "column_value" you want in your resultset?