MySQL Question

Hi there! I am sorry posting this message in a PHP list, but I didn't find any mysql or sql newsgroup. I have two tables in my database. Lets call the one "article" and the other "author". In the table article is a field called author, which only includes the id of the articles author. To get the article and author information I gotta do the following SELECT * FROM article WHERE id LIKE '1' and then SELECT * FROM author WHERE id LIKE '123' <--- the id from the other query Is there any possibility doing this in just one SQL Query? Thanks. Simon --- netdienste GbR internet & multimedia Geisselstrasse 19 50823 Koeln tel: +49 221 - 932 958 2 fax: +49 221 - 932 958 5 s.biela@netdienste.de http://www.netdienste.de red:pepper - das redaktionssystem www.redpepper.netdienste.de