You can use "select u.a as u.a, v.a as v.a .." Best regards, Shiqi Yang -----Original Message----- From: adolfas [mailto:adolfas@xxxxxxx] Sent: Tuesday, July 12, 2005 2:42 PM To: php-general@xxxxxxxxxxxxx Subject: Plz, help Hi, I have a line: $sql="select u.*, p.name_lt as pareiga from nese_users u left join nese_pareigos p on p.id=u.pareiga order by data desc"; As I understand there are 2 tables: nese_users and nese_pareigos I need to know what atributes belong to what table form that line. Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
