Clickable Author

Sure, you can use 'View as' type Custom for this purpose. Assuming that field name is AuthorId is both Authors and Books table here is the code you can use:

Dear Admin,

Thank you very much for your quick answer and help.

However, I could not run this code. After inserting this code, AuthorId begins to show "Books by this auhor" for all authors, and it does not filter the appropriate entries.

I would like to keep authors' names as long as they are clickable.
If I could run a code provided by you, I intend to use it for other columns such as series, tag etc.
I am not so good at databases, so may be I did something wrong.

After inserting this code, AuthorId begins to show "Books by this auhor" for all authors, and it does not filter the appropriate entries.

You are leaving out important information.
1rst question: I presume you have a table perhaps called 'titles' with row after row of book titles and in a different column called 'AuthorId' of this table you have the same number that is called "AuthorId" in the 'authors' table?
Do you have 2 tables that are related to each because they have a column called 'AuthorId'?

One table is all Author names and their assigned AuthorId number.

The other table is all those 'titles' with the AuthorId column filled with the same number, once in the Authors table, and multiple times in the 'titles' table.
So that when AuthorId 5 is selected that the query says something like "Select titles WHERE 'titles'.'AuthorId' = 5 SORT BY 'titles' " or maybe
"Select titles WHERE AuthorId = '5' "

Dear Maverick,
I have separate tables for each Id Columns. A table for Author, a table for series, a table for publication place, a table for publisher etc.
Let's make it simpler:
I would like to be able to click the name of an author, and the result will be like this:
..._list.php?q=(AuthorId~equals~AuthorId)
I would like to be able to click the series, and the result will be like this:

..._list.php?q=(Series~equals~SeriesId)

But this exactly what code I provided does.