Hi,
try complete your query by adding word 'AS' syntax:
field AS name
so:
select USERS.name AS name1, USERS.name AS name2, USERLIST.user_id AS
id1, STUDENTLIST.user_id AS id2 student_id
from USERS, USERLIST, STUDENTLIST
WHERE
Michal Dvoracek [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php