hello all i have a problem in mysql . i have three table like audio video and download, all tables have a coloumn name user id.i want to fetch a user whose id is equal to session(user id) from all three tables. how i can do this. i also tried join but not getting aspected result please help me. Rahul Dongre The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ [Non-text portions of this message have been removed]