Thanks for your solution Adam.

hey frnd dont get mistaken me...

i need to get message count from question_details,blogs count from blog_detail,personal information from personal_details of all user who are in account_details table.

account_details Columns: username,password

personal_details Columns:username,fname,laname,mailid

question_details...

hey thanks a lot frnd...Ur query is working fine..

i have another need also...

In previous i mentioned three tables

account_details Columns: username,password

personal_details Columns:username,fname,laname,mailid

question_details Columns:usename,qid,questions,answers

and i asked personal details and message count...