If you post your DDL you can get an exact answer, without it, here's
best guess

tbl - authors
tbl - book
tbl - junction

select a.author_id,b.book_id
from authors a join junction j
on a.author_id = j.author_id
join book b on b.book_id = j.book_id

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!