hi my database table is like sl no month data t1 03 234 t1 04 678 t1 05 1234 t2 03 789 t2 04 0909 t2 05 456 l but i want like this query sl.no data1 dat2 dat3 t1 234 678 123 t2 789 0909 456 please help..

Hi ancy chacko , Example : Use GROUP_CONCAT() like this: SELECT k . id , GROUP_CONCAT ( d . value ) FROM keywords AS k INNER JOIN data as d ON k . id = d . id GROUP BY k . id Ref this : http://stackoverflow.com/questions/3664393/how-to-group-mysql-rows-with-same-column-value-into-one-row