I am using microsoft access(unfortunately I have no choice) to create queries.

I have a main table that contains information about a book(one) and 2 secondary tables(many)

Book Table
ID,Title

Keyword Table
Keyword, foreign_key(ID from book table)

Author Table
Author Name, foreign_key(ID from book table)

I want to do the following:

Author,Keyword, Title, ID

Say I have the data like this
Book Table:
1 Bob's Poker Tips
2 Bob's Cookbook

Keyword Table
2 Baking
2 Stewing
1 Texas Holdem

Author Table
2 Joe Smith
2 Bob Perini
1 Bob Perini

If I query the author Bob Perini

I'm currently getting from my query:
ID,AUTHOR,KEYWORD,TITLE
1 Bob Perini Texas Holdem Bob's Poker Tips
2 Bob Perini Baking Bob's Cookbook
2 Bob Perini Stewing Bob's Cookbook

I want to get the following:
ID,AUTHOR,KEYWORD,TITLE
1 Bob Perini Texas Holdem Bob's Poker Tips
2 Bob Perini Baking,Stewing Bob's Cookbook

If you don't know the syntax for the Jet SQL engine, then feel free to share the theory or show me a query in someone other sql.

Thanks in advance

It sounds like you have a Microsoft Access question instead of a design question. Try posting in the Microsoft Access forum.

actually, it is (also) very much a design question

this question comes up all the time, and the answer is:

do it with a scripting language after you've applied an ORDER BY to the query to ensure the result rows come back in in the right order to allow current/previous logic

i.e. don't try to do this with sql

are people cheating on line poker like 3 people playing at same table talking to each