You can use "select u.a as u.a, v.a as v.a .." Best regards, Shiqi Yang
-----Original Message----- From: adolfas [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 12, 2005 2:42 PM To: php-general@lists.php.net Subject: [PHP] 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