Join syntax question

Consider this simplified table structure:

[Books]

ID
TITLE
[Authors]

ID
BOOKID
NAME The problem: Books may have no authors, one author or mulitple authors. I need a query that shows a list of books and only one author (doesn't matter which one) or NULL if no authors exist, each book can only be listed once.

Any input would be greatly appreciated.

Thanks,
Dan Lamb
lamb dot dan at gmail dot com Received on Wed Jun 15 2005 - 07:13:23 CDT