NEWBIE - Needs Assistance with Joins

Hello, I have two tables, one that contains an item id, album title name, and artist ID number. The second table is a list of artists, with an auto-increment artist ID. I want to join the two tables and have them output to a single PHP page. I was following along with the tutorial at http://www.webmasterbase.com/article/228/, and tried to modify it for my own needs. When I do this, I get a parse error on the line that starts with SELECT. Here's the code: $Link = mysql_connect ($Host, $User, $Password); $CDList =mysql_query( "SELECT artist_name, album_title ". "FROM artists, album_titles WHERE artist_id = aid"); What am I doing wrong? Thanks in advance.