+---------------+
|     AUTHOR    |
+---------------+
 id | name

+-----------------+
|     POST        |
+-----------------+
|id |title|content|

+------------------------------+
|           RESULT             |
+------------------------------+
id | name | id | title | content

SELECT columns FROM Author INNER JOIN Result ON Author.id = Result.id;

select * from author, posts

select authoer.id,authoer.name,posts.id,posts.name,posts.title,post.content from author,posts
    where authoer.id=posts.id

select a.id, a.name, p.id, p.title, p.content
FROM author a
INNER JOIN post p ON a.id = p.id;

SELECT A.ID,A.NAME,B.ID,B.TITLE,B.CONTENT
FROM POST A
INNER JOIN AUTHOR B
ON A.ID=B.ID