O.k, what is the structure of your tables, what does your join statement look like, what results are you expecting, and what results are you getting? --- In php-objects@xxxxxxxxxxxxxxx, rahul dongre <mady_dongre@...> wrote: > > > > 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] >