Use the column name with table name separated by dot (.).
For eg: SELECT * FROM users, sessions WHERE users.user_id = sessions.user_id
Thanks & Regards
Udayakumar Sarangapani
Team Lead - PHP
CompIndia Infotech Pvt. Ltd.
Chennai.
"Science is nothing but logic..."
________________________________
From: rahul dongre <mady_dongre@xxxxxxxxxxx>
To: php-objects@xxxxxxxxxxxxxxx
Sent: Mon, 23 November, 2009 11:51:56 PM
Subject: problem in mysql
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]
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
[Non-text portions of this message have been removed]
