Hello all I am having trouble with joining tables i will explain.
I have four tables Cat - CatFile - File - User. thay are related in the order. I need to join them around the file table. i tryed 'SELECT cat.name, catfile.catid, file.fileid, user.name FROM cat RIGHT JOIN catfile ON catfile.catid=cat.catid RIGHT JOIN file ON file.fileid=catfile.fileid LEFT JOIN user ON file.userid=user.userid' i get a list as long as my arm most of which are not what i am trying to get -- eschew obfuscation. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]